> 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
- [HACKERS] ALL, ANY bug? Tatsuo Ishii
- Re: [HACKERS] ALL, ANY bug? Tom Lane
- Re: [HACKERS] ALL, ANY bug? Tatsuo Ishii
- Re: [HACKERS] ALL, ANY bug? Tom Lane
- Tatsuo Ishii