From: Greg Stark <gsstark@mit.edu>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Greg Stark <gsstark@mit.edu>
Cc: mailreg@numerixtechnology.de
Cc: pgsql-patches@postgresql.org
Subject: Re: [SQL] COUNT(*) to find records which have a certain number of dependencies ?
Date: 21 Sep 2004 13:14:15 -0400
Message-ID: <878yb3fst4.fsf@stark.xeocode.com> (raw)
In-Reply-To: <23046.1095722596@sss.pgh.pa.us>
References: <414EF3E6.9040202@numerixtechnology.de>
<87llf4hjv2.fsf@stark.xeocode.com>
<414F348A.2020608@numerixtechnology.de>
<877jqohdoj.fsf@stark.xeocode.com>
<414F43A8.8000101@numerixtechnology.de>
<87y8j4fwmb.fsf@stark.xeocode.com>
<23046.1095722596@sss.pgh.pa.us>
Tom Lane <tgl@sss.pgh.pa.us> writes:
> Greg Stark <gsstark@mit.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...
I understand. But I expect there are lots of users this annoys. It's just such
an easy thing to work around that it would be a petty thing to complain about.
That's the only reason I never complained about it all this time it was
annoying me. Not until I felt ready to poke around and fix it myself.
And I'm not suggesting ignoring the spec, just allowing the user to ignore it,
and not having postgres go out of its way to enforce the spec on users.
I doubt the spec says that the implementation cannot allow the syntax.
...Ok, well I wouldn't put it past the spec to do so. But it does so about
lots of things that Postgres allows. The general attitude postgres has seems
to be to extend the spec whenever it's nice for the user as long as doing so
doesn't interfere with actually supporting any spec compliant code. It's not
like postgres is a good platform for testing spec compliance of SQL code
otherwise.
It just seems excessively obnoxious to refuse queries because they don't match
a grammar precisely when the missing piece is entirely not needed by the
database. It doesn't cause any ambiguity or other problems with the SQL. It
doesn't cost a single cycle in the normal case. The code doesn't impact
anything else in the system. It's the database being intentionally nosy and
picky about something just because it can.
--
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, tgl@sss.pgh.pa.us, mailreg@numerixtechnology.de, pgsql-patches@postgresql.org
Subject: Re: [SQL] COUNT(*) to find records which have a certain number of dependencies ?
In-Reply-To: <878yb3fst4.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