Re: [GENERAL] Convert to upper

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) CHE

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

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. S