On Tue, Aug 19, 2003 at 21:24:50 +0800,
Chris M <[EMAIL PROTECTED]> wrote:
> I also find something magic when using sequence.
> select nextval('seq_test');
> and
> select nextval('"seq_test"');
> both refer to the same sequence: seq_test.
>
> If I want to use a sequence with name: SEQ_TE
I also find something magic when using sequence.
select nextval('seq_test');
and
select nextval('"seq_test"');
both refer to the same sequence: seq_test.
If I want to use a sequence with name: SEQ_TEST,
I have to write it as:
select nextval('"SEQ_TEST"');
So single quotes '...' here n
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Can someone comment on this?
This is unfixable as long as nextval() and friends depend on string
parameters to represent table references. There are suggestions in
our archives about how we might move to a more Oracle-like syntax
(ie, table.nextval), wh
Can someone comment on this?
---
Andreas Hinz wrote:
> If PostgreSQL failed to compile on your computer or you found a bug that
> is likely to be specific to one platform then please fill out this form
> and e-mail it to [EM
