Hi, 2010/5/27 Tom Lane <[email protected]>: > Harrie Rodenbach <[email protected]> writes: >> = oratest=# select odbclink.query(1, 'SELECT * FROM mytable') as >> result(id int4, t text, d decimal); = ERROR: syntax error at or near >> "(" = LINE 1: ...bclink.query(1, 'SELECT * FROM mytable') as >> result(id int4, ... > > You need that to be select * from odbclink.query ... > the "as" business is only allowed in FROM clause. > > regards, tom lane > That did the trick, thank you Tom. Next problem will be described in a new thread.
-- Met vriendelijke groet / with kind regards, Harrie Rodenbach -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
