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
signature.asc
Description: This is a digitally signed message part