From: Greg Stark <gsstark@mit.edu>
To: mailreg@numerixtechnology.de
Cc: Greg Stark <gsstark@mit.edu>
Cc: pgsql-sql@postgresql.org
Subject: Re: COUNT(*) to find records which have a certain number of dependencies ?
Date: 20 Sep 2004 16:45:48 -0400
Message-ID: <877jqohdoj.fsf@stark.xeocode.com> (raw)
In-Reply-To: <414F348A.2020608@numerixtechnology.de>
References: <414EF3E6.9040202@numerixtechnology.de>
<87llf4hjv2.fsf@stark.xeocode.com>
<414F348A.2020608@numerixtechnology.de>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gsstark@mit.edu, mailreg@numerixtechnology.de
Subject: Re: COUNT(*) to find records which have a certain number of dependencies ?
In-Reply-To: <877jqohdoj.fsf@stark.xeocode.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox