Hello,
H2 uses a very similar syntax like PostgreSQL to fetch NEXTVAL() and
CURRVAL() values from sequences. However, H2 doesn't really support
explicitly specifying case-senstive literals using quotes. In PostgreSQL, I
can write:
nextval('foo') *operates on sequence foo*
nextval('FOO') *operates on sequence foo*nextval('"Foo"') *operates on
sequence Foo*
The sequence name can be schema-qualified if necessary:
nextval('myschema.foo') *operates on myschema.foo*nextval('"myschema".foo')
*same as above*
nextval('foo') *searches search path for foo*
As documented here:
http://www.postgresql.org/docs/9.3/static/functions-sequence.html
I think it would be useful to also support those quotes in sequence names.
What do you think?
Cheers
Lukas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
