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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: mailreg(at)numerixtechnology(dot)de, pgsql-patches(at)postgresql(dot)org
Subject: Re: [SQL] COUNT(*) to find records which have a certain number of dependencies ?
Date: 2004-09-20 23:23:16
Message-ID: 23046.1095722596@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches pgsql-sql

Greg Stark <gsstark(at)mit(dot)edu> 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 mind waiting for
quite a few complaints before contemplating changing this...

regards, tom lane

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Ed L. 2004-09-20 23:25:20 Re: log_filename_prefix --> log_filename + strftime()
Previous Message Tom Lane 2004-09-20 22:57:01 Re: log_filename_prefix --> log_filename + strftime()

Browse pgsql-sql by date

  From Date Subject
Next Message Dean Gibson (DB Administrator) 2004-09-21 00:10:58 Re: JOIN performance
Previous Message Tom Lane 2004-09-20 23:06:14 Re: JOIN performance