Re: Do not understand "SETOF RECORD" - therefore can not use ODBC-link

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