On Wed, Aug 06, 2003 at 03:06:12PM +0100, Jan Oksfeldt Jonasen wrote: > At 01:40 PM 8/6/2003, Peter Eisentraut wrote: > >You need to double-quote the names or they will be converted to lower > >case. > > > > Thank you both. The reason why the initial table creation have quoted > columns names is that it's generated by a program we use for schema > creation. I'm currently adding to it so it can support Postgres too and the > way columns are set up was more or less copied from the MS Sql > implementation. > > I'm really not used to databases being so case sensitive, neither Oracle or > MS Sql Server is that, but I'll keep this thing in mind moving along. Quite > impressed with the response time, or maybe it was just a too easy question > :-)
Well, it's only case-sensetive if you ask for it, ie by quoting. The basic rule is: Either always quote or never quote. Always quote = case-sensetive Never quote = case-insensetive -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > "All that is needed for the forces of evil to triumph is for enough good > men to do nothing." - Edmond Burke > "The penalty good people pay for not being interested in politics is to be > governed by people worse than themselves." - Plato
pgp00000.pgp
Description: PGP signature
