To: mailreg@numerixtechnology.de
Cc: Greg Stark <gsstark@mit.edu>, pgsql-sql@postgresql.org
Subject: Re: COUNT(*) to find records which have a certain number of
	dependencies ?
References: <414EF3E6.9040202@numerixtechnology.de>
	<87llf4hjv2.fsf@stark.xeocode.com>
	<414F348A.2020608@numerixtechnology.de>
In-Reply-To: <414F348A.2020608@numerixtechnology.de>
From: Greg Stark <gsstark@mit.edu>
Organization: The Emacs Conspiracy; member since 1992
Date: 20 Sep 2004 16:45:48 -0400
Message-ID: <877jqohdoj.fsf@stark.xeocode.com>
Lines: 30
User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii


T E Schmitz <mailreg@numerixtechnology.de> writes:

> ) as somealias on (model_fk = model_pk)
> 
> (subquery in FROM must have an alias)

ARGH! This is one of the most annoying things about postgres! It bites me all
the time. Obviously it's totally insignificant since it's easy for my to just
throw an "AS x" on the end of it. But damn.

I see there's a comment foreseeing some annoyance value for this in the
source:

          /*
           * The SQL spec does not permit a subselect
           * (<derived_table>) without an alias clause,
           * so we don't either.  This avoids the problem
           * of needing to invent a unique refname for it.
           * That could be surmounted if there's sufficient
           * popular demand, but for now let's just implement
           * the spec and see if anyone complains.
           * However, it does seem like a good idea to emit
           * an error message that's better than "syntax error".
           */

So where can I officially register my complaint? :)

-- 
greg