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