Hi Devs, I am just trying out Base 3.2.0 with a postgresql 8.1 server. Very easy to get going, but I noticed that some complex select statements generate syntax errors in base, but work fine via psql. There don't seem to be any select bugs/limitations listed here: http://dba.openoffice.org/drivers/postgresql/index.html. I am using 'Create query in SQL view' to test them.
An example is: select count(*) from (select distinct on (mac) mac from node where cast(switch as text) NOT LIKE '10.10.16.%') as foo; This returns 3 syntax errors, error code 1000. The last error has the additional text "syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE" cheers, yrebrac
