Re: Uppercase field names not found - Mailing list pgsql-admin

From David Stanaway
Subject Re: Uppercase field names not found
Date
Msg-id 1024436877.9395.42.camel@ciderbox
Whole thread Raw
In response to Re: Uppercase field names not found  (Digital Wokan <wokan@cox.net>)
List pgsql-admin
On Tue, 2002-06-18 at 16:58, Digital Wokan wrote:
> So I suppose since he's referring to a field, to pull it in all
> uppercase, he'd use...
> SELECT "ABC" from mytable;
> Am I correct?


Yes.  Same with functions too I guess.  Sequences were tricky,
I think.. you needed:   currval('"mytable_ABC_seq"')

I avoid non-lower case names personally. It is not very portable to rely
on that in your application and will be confusing if anyone else messes
with your code.

--
David Stanaway

Attachment

pgsql-admin by date:

Previous
From: Brian McCane
Date:
Subject: Re: Removing records that violate foreign key
Next
From: Jean-Christophe ARNU (JX)
Date:
Subject: index keeps on growing