Hi all,
The change log for 1.3.161 refers to "Improved compatibility for
"fetch first / next row(s)""
(http://www.h2database.com/html/changelog.html)
However, with "H2 1.3.161 (2011-10-28)" I cannot seem to use this:
select 1 fetch first 1 row only;
Syntax error in SQL statement "SELECT 1 FETCH FIRST[*] 1 ROW ONLY ";
SQL statement:
select 1 fetch first 1 row only [42000-161] 42000/42000 (Help)
The same statement works fine in PostgreSQL which I know supports it
--
postgres=# select 1 fetch first 1 row only;
?column?
----------
1
(1 row)
This is expected to work, yes?
--
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.
