Hi,
2010/5/27 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Harrie Rodenbach <marktenveiling(at)gmail(dot)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
>
That did the trick, thank you Tom. Next problem will be described in a
new thread.
--
Met vriendelijke groet / with kind regards,
Harrie Rodenbach