Re: PostgreSQL SQL92: CORRESPONDING BY

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@uab.edu
Phone: (205)934-6759
Fax: (205)934-0480

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@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