Re: [PATCHES] [SQL] COUNT(*) to find records which have a certain number of dependencies ?

2004-09-21 Thread Greg Stark
Tom Lane <[EMAIL PROTECTED]> writes: > Greg Stark <[EMAIL PROTECTED]> writes: > > This patch allows subqueries without aliases. This is SQL-non-spec-compliant > > syntax that Oracle supports and many users expect to work. > > AFAIR you're the first to propose that we ignore the SQL spec here. >

Re: [PATCHES] [SQL] COUNT(*) to find records which have a certain number of dependencies ?

2004-09-20 Thread Tom Lane
Greg Stark <[EMAIL PROTECTED]> writes: > This patch allows subqueries without aliases. This is SQL-non-spec-compliant > syntax that Oracle supports and many users expect to work. AFAIR you're the first to propose that we ignore the SQL spec here. When I wrote "see if anyone complains", I had in mi

Re: [PATCHES] [SQL] COUNT(*) to find records which have a certain number of dependencies ?

2004-09-20 Thread Greg Stark
T E Schmitz <[EMAIL PROTECTED]> writes: > There's a German saying "Go and find a parking-meter", i.e. suggesting to pop a > coin in the parking-meter and talk to it as nobody else wants to listen. ;-) Yes well I anticipated such a response. So I tried my hand at it myself. Well I finally found