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

2010-06-02 Thread Harrie Rodenbach
Hi, 2010/5/27 Tom Lane : > Harrie Rodenbach 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 my

[SQL] Do not understand "SETOF RECORD" - therefore can not use ODBC-link

2010-05-27 Thread Harrie Rodenbach
returning record called in context that cannot accept type record So it seems the functions returns data, but I do not know how to display it. Since I do not understand how to handle SETOF RECORD I can not solve the problem myself. We're running PostgreSQL 8.4.3, ODBC-link 1.0. Any he