any limitations on select statements with postgres driver?

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