GRR, not enough coffee yet today :(

<action>Jonah now enjoys some Sumatra</action>

On 3/8/06, Jonah H. Harris <[EMAIL PROTECTED] > wrote:
I agree wholeheartedly.

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

Reply via email to