pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: [SQL] Outer Joins, Foreign keys, subselects
4+ messages / 3 participants
[nested] [flat]

* Outer Joins, Foreign keys, subselects
@ 1999-07-28 01:19 Jens Glaser <jens@helena.jens.de>
  1999-07-28 00:10 ` Re: [SQL] Outer Joins, Foreign keys, subselects Bruce Momjian <maillist@candle.pha.pa.us>
  0 siblings, 1 reply; 4+ messages in thread

From: Jens Glaser @ 1999-07-28 01:19 UTC (permalink / raw)
  To: pgsql-sql

Hi,

I know I'm stealing your time, but ...

is there work being done already on the above mentioned features?

Is there an immediate need for help?

Regards,

-- 
Jens Glaser     Am Holderstrauch 13, 36041 Fulda, 0661/9429507    jens@jens.de




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] Outer Joins, Foreign keys, subselects
  1999-07-28 01:19 Outer Joins, Foreign keys, subselects Jens Glaser <jens@helena.jens.de>
@ 1999-07-28 00:10 ` Bruce Momjian <maillist@candle.pha.pa.us>
  1999-07-31 13:56   ` Re: [SQL] Outer Joins, Foreign keys, subselects Jens Glaser <jens@helena.jens.de>
  0 siblings, 1 reply; 4+ messages in thread

From: Bruce Momjian @ 1999-07-28 00:10 UTC (permalink / raw)
  To: jens@jens.de; +Cc: pgsql-sql

> Hi,
> 
> I know I'm stealing your time, but ...
> 
> is there work being done already on the above mentioned features?
> 
> Is there an immediate need for help?
> 

We have subselects, and plan to add outer joins and foreign keys in 6.6.
Our TODO list is on our web site.
-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] Outer Joins, Foreign keys, subselects
  1999-07-28 01:19 Outer Joins, Foreign keys, subselects Jens Glaser <jens@helena.jens.de>
  1999-07-28 00:10 ` Re: [SQL] Outer Joins, Foreign keys, subselects Bruce Momjian <maillist@candle.pha.pa.us>
@ 1999-07-31 13:56   ` Jens Glaser <jens@helena.jens.de>
  1999-07-31 15:58     ` Re: [SQL] Outer Joins, Foreign keys, subselects Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 4+ messages in thread

From: Jens Glaser @ 1999-07-31 13:56 UTC (permalink / raw)
  To: Bruce Momjian <maillist@candle.pha.pa.us>; +Cc: pgsql-sql

Hi,

On Tue, 27 Jul 1999, Bruce Momjian wrote:
> 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!

Regards,

-- 
Jens Glaser     Am Holderstrauch 13, 36041 Fulda, 0661/9429507    jens@jens.de




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] Outer Joins, Foreign keys, subselects
  1999-07-28 01:19 Outer Joins, Foreign keys, subselects Jens Glaser <jens@helena.jens.de>
  1999-07-28 00:10 ` Re: [SQL] Outer Joins, Foreign keys, subselects Bruce Momjian <maillist@candle.pha.pa.us>
  1999-07-31 13:56   ` Re: [SQL] Outer Joins, Foreign keys, subselects Jens Glaser <jens@helena.jens.de>
@ 1999-07-31 15:58     ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 4+ messages in thread

From: Tom Lane @ 1999-07-31 15:58 UTC (permalink / raw)
  To: jens@jens.de; +Cc: Bruce Momjian <maillist@candle.pha.pa.us>; pgsql-sql

Jens Glaser <jens@helena.jens.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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~1999-07-31 15:58 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-07-28 01:19 Outer Joins, Foreign keys, subselects Jens Glaser <jens@helena.jens.de>
1999-07-28 00:10 ` Bruce Momjian <maillist@candle.pha.pa.us>
1999-07-31 13:56   ` Jens Glaser <jens@helena.jens.de>
1999-07-31 15:58     ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox