Re: PostgreSQL SQL92: CORRESPONDING BY

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "David H(dot) Johnson" <dhj(at)uab(dot)edu>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: PostgreSQL SQL92: CORRESPONDING BY
Date: 2002-06-18 20:53:16
Message-ID: 200206182053.g5IKrGw27393@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


I received this via private email. Do we want CORRESPONDING added to
the TODO list?

---------------------------------------------------------------------------

David H. Johnson wrote:
> Hi,
>
> I am writing you because you're listed as the TODO List maintainer. I noticed
> that PostgreSQL does not support the CORRESPONDING BY clause for
> UNION/INTERSECT/EXCEPT. The only reference I have found to this functionality
> in the mailing list archives is this message by Tom Lane:
>
> http://fts.postgresql.org/db/mw/msg.html?mid=1273164
>
> In the message he discusses a rewrite of UNION/INTERSECT/EXCEPT for PostgreSQL
> 7.1 to allow them to work with views and subselects. Tom also says that he
> will not try to implement the CORRESPONDING option, but that it should be a
> fairly straightforward extension when it is attempted.
>
> I was wondering if you (or the PostgreSQL development team) would consider
> adding the CORRESPONDING option of UNION/INTERSECT/EXCEPT queries to the TODO
> list.
>
> Thanks for reading.
>
> --David
>
> --
> David H. Johnson, Engineer I
> University of Alabama at Birmingham
> Center for Biophysical Sciences and Engineering
>
> E-mail: dhj(at)uab(dot)edu
> Phone: (205)934-6759
> Fax: (205)934-0480
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2002-06-18 21:55:20 Re: Roadmap for a Win32 port
Previous Message Dann Corbit 2002-06-18 20:50:50 Re: ECPG won't compile anymore