Re: [GENERAL] Convert to upper

[Peter Schindler]

Matthias,

the easiest way is to use CHECK constraints. see example below.

Servus,
Peter

Matthias Teege wrote:
 is there any way to limit values to upper case strings?
 Somthing like:
 
 name char(15) DEFAULT (upper(name))
 
 or must I use triggers?

test=# create table bla(bb char(10) CHECK (bb =UPPER(bb)));
CREATE
test=# \d bla
 Table "bla"
 Attribute | Type  | Modifier
---+---+--
 bb| character(10) |
Constraint: ((bb)::text = upper((bb)::text))

test=# insert into bla values ('OTTO');
INSERT 381409 1
test=# insert into bla values ('otto');
ERROR:  ExecAppend: rejected due to CHECK constraint bla_bb
ERROR:  ExecAppend: rejected due to CHECK constraint bla_bb
test=# select * from bla;
 bb

 OTTO
(1 row)

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] has anybody gotten cygwin1.1.8 to work with postgresql?

[Peter Schindler]

Jeff,

Jeff wrote:
 I've tried fruitlessly to install cygwin1.1.8 work with postgresql7.03
 
 Has any body out there done it?
What is actually wrong with the install? If you can't start the postmaster,
because its complains about the IPCs, I fall over the same problem, but 
actually with 7.1. Some other guys investigated it already,
and there is a problem with the IPCs with cygwin1.1.8
So their suggestion is to downgrade to 1.1.7, but there is 
trap when doing it, because of locked dlls.

Have a look into the threads of the -ports mailing lists of Feb2001,
especially this below, when downgrading:

http://www.postgresql.org/mhonarc/pgsql-ports/2001-02/msg00084.html

 Where can I get the latest postgresql7.1?
http://www.postgresql.org/sites.html

Peter