| From: | "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com> |
|---|---|
| To: | "Neil Conway" <neilc(at)samurai(dot)com> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Stephan Szabo" <sszabo(at)megazone(dot)bigpanda(dot)com>, "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, "Hans-J?rgen Sch?nig" <postgres(at)cybertec(dot)at>, "Michael Glaesemann" <grzm(at)myrealbox(dot)com>, pgsql-patches(at)postgresql(dot)org, eg(at)cybertec(dot)at |
| Subject: | Re: CREATE SYNONYM ... |
| Date: | 2006-03-08 14:18:15 |
| Message-ID: | 36e682920603080618v5eeaae82t885c47c8e1893853@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
GRR, not enough coffee yet today :(
<action>Jonah now enjoys some Sumatra</action>
On 3/8/06, Jonah H. Harris <jonah(dot)harris(at)gmail(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-03-08 15:27:48 | Re: pg_freespacemap question |
| Previous Message | Jonah H. Harris | 2006-03-08 14:14:32 | Re: CREATE SYNONYM ... |