Harrie Rodenbach <marktenveil...@gmail.com> 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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
