Re: [HACKERS] Table functions and AS clauses ...

2003-06-17 Thread Joe Conway
Hans-Jürgen Schönig wrote: However, my question is: Is there a way to implement it in a way that does not depend on the remote data structure? Is there a way to get rid of the AS without having to define a type? Unfortunately, no. The parse and planning stages need defined types, so waiting for t

[HACKERS] Table functions and AS clauses ...

2003-06-16 Thread Hans-Jürgen Schönig
Currently I am able to do ... SELECT dblink_oraconnect('scott/[EMAIL PROTECTED]'); SELECT * FROM dblink_ora('SELECT ename, sal FROM emp') AS (ename text, sal text); The problem is: If I wanted to do a SELECT * FROM dblink_ora('SELECT * FROM emp'); It won't work because dblink_ora returns