Re: Do not understand "SETOF RECORD" - therefore can not use ODBC-link - Mailing list pgsql-sql

Harrie Rodenbach <marktenveiling@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