Re: ALL, ANY bug? - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: ALL, ANY bug?
Date
Msg-id 20010108181256Z.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: ALL, ANY bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> No, I still disagree.  The ANY/ALL constructs compare a single row on
> the left side with all the rows produced by the query on the right.
> "values(0,1)" is effectively the same as "SELECT 0,1", ie, it is a
> query that happens to produce just one row.  The above is illegal in
> SQL92 because the lefthand side is not a two-item row.

Oh, I see your point. values(0,1) = SELECT 0,1", which is one row
constructor. Sorry for the confusion.
--
Tatsuo Ishii


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ALL, ANY bug?
Next
From: Pete Forman
Date:
Subject: Re: pg_dump return status..