Hi,
> That new syntax does the trick, thanks. I notice that the case seems
> to matter.
Yes, this syntax is case sensitive. The regular nextval('...') is not
however (and will not be).
> The case
> does not seem to matter in "create sequence" or "create schema".
That's because the database converts unquoted names to uppercase. See also:
http://www.h2database.com/html/grammar.html#name
http://www.h2database.com/html/grammar.html#quotedname
> I confess ignorance as to how this should actually work in standard SQL,
> but it is a surprise.
As far as I know, H2 works like defined by the SQL standard. Other
databases work differently.
> I work out of svn, so I'll keep an eye out for that fix.
It is now in the SVN.
Regards,
Thomas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
