Re: [BUGS] Subselects lack functionality

2000-09-28 Thread Tom Lane
[EMAIL PROTECTED] writes: > Subselects don't allow one to use tuple set operators like UNION, > INTERSECT, EXCEPT. Yeah, we know. The existing implementation of UNION etc. is a horrid kluge that only works at the top level of a SELECT (and not even very well there). Fixing this will require a r

Re: [BUGS] Subselects lack functionality

2000-09-28 Thread Lamar Owen
[EMAIL PROTECTED] wrote: > 2. > It would be gr8 if single column subselects would allow themselves to be treated the >same way as lists do as right-side arguments of IN operator. > This would allow e.g. much more powerful DELETE statement, like > DELETE FROM table WHERE id IN (SELECT ...) This,

[BUGS] Subselects lack functionality

2000-09-28 Thread pgsql-bugs
Kuba Ober ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Subselects lack functionality Long Description 1. Subselects don't allow one to use tuple set operators like UNION, INTERSECT, EXCEPT. It forces one to select the resul