2014-08-12 16:41 GMT+02:00 Noel Grandin <[email protected]>: > Hmmm. > > Our current support is fairly ... extensive :-) > > We support > nextval('SCHEMA.SEQUENCE') > nextval('SCHEMA', 'SEQUENCE') > and in both these cases we will do a case-sensitive match, and if that > fails, a case-insensitive match. >
Interesting, I wasn't aware of this algorithm :-) > We also support: > sequence.NEXTVAL > schema.sequence.NEXTVAL > "sequence".NEXTVAL -- for case-sensitive identifiers > I wasn't aware of this either! Thanks for pointing it out. > I don't see why we can't add PostgreSQL's peculiar variant to that, given > how much variation we already support :-) H2 is the dump of all the world's SQL syntax, I guess ;-) -- 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.
