| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | jens(at)jens(dot)de |
| Cc: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] Outer Joins, Foreign keys, subselects |
| Date: | 1999-07-31 15:58:30 |
| Message-ID: | 13522.933436710@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Jens Glaser <jens(at)helena(dot)jens(dot)de> writes:
>> We have subselects, and plan to add outer joins and foreign keys in 6.6.
> well, but AFAIK not of the form e.g.
> select blabla from (select * from asdasd ..) t1,
> (select * from bsdfsd ..) t2, where t1.pkey=t2.pkey
> ..
> (subselects in the target list). SCR!
Actually, Jan is saying that that's exactly what he needs to make rules
work Really Right. If we add subselect RTEs for the rule rewriter,
I see no reason that we couldn't provide them for direct use too.
Might not happen for 6.6, but maybe the version after.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stéphane FILLON | 1999-07-31 22:12:25 | Tr: UNIQUE |
| Previous Message | Jens Glaser | 1999-07-31 13:56:47 | Re: [SQL] Outer Joins, Foreign keys, subselects |