GRR, not enough coffee yet today :(
<action>Jonah now enjoys some Sumatra</action>
On 3/8/06, Jonah H. Harris <jonah.harris@gmail.com > wrote:
regarding "we should take a fresh look at the problem rather than just blindly copying a construct from Oracle".
SELECT dblink('host=somehost dbname=remotedb ...', 'SELECT emp_id,first_name,last_name,middle_name,birth_dt,ssn,... FROM EMPLOYEE WHERE last_name = ''Blow''') AS t1(emp_id BIGINT, first_name VARCHAR, last_name VARCHAR, middle_name VARCHAR, birth_dt DATE, ssn NUMERIC, ...)
should be SELECT * FROM ...
--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324