From: | Don Baccus <dhogaza(at)pacifier(dot)com> |
---|---|
To: | Philip Warner <pjw(at)rhyme(dot)com(dot)au>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Phantom row from aggregate in self-join in 6.5 |
Date: | 1999-07-23 01:57:54 |
Message-ID: | 3.0.1.32.19990722185754.00e36f54@mail.pacifier.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
At 11:39 AM 7/23/99 +1000, Philip Warner wrote:
>I've now checked Dec Rdb, SQL/Server, and MS-Access - and they return 0
rows. Add this to Informix, and one begins to wonder if there are any that
match the Postgres behaviour?
>Any idea where I can find a copy of the SQL92 standard on the net?
I'd like an answer to this, too :)
It may be that you've stumbled into an area the standard's either
left "implementation-dependent", "undefined", or simply forgotten
or unthought-of. (can you tell I've been drafted into ANSI/ISO
standards efforts in the past for Pascal and Modula-2?)
Still, I must say that a row returning "0" in response to a
count(*) isn't at all suprising, I guess it's a matter of
whether or not the count(*) or the specific column being
extracted determines the behavior.
>>You'll find several past discussions of this point in the pgsql-hackers
>>archives, and they all seem to have ended inconclusively.
>I had a quick look at discussions involving informix, but could not find
anything. Can you give a little more information about the past
discussions, and specifically, what the reasons for preserving this
behaviour were?
First, I wouldn't trust Access to be much of an SQL standards judge.
If nothing else, MS's collaboration with Sybase (SQL/Server) might
perhaps color MS's view of what the standard sez. Not to mention
the poaching of parser/semantic code, etc...
And doesn't DEC Rdb have some genealogical relationship to SQL/Server?
(I could be WAY off base here)
- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
Nature photos, on-line guides, and other goodies at
http://donb.photo.net
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-07-23 02:01:49 | Re: [PORTS] RedHat6.0 & Alpha |
Previous Message | Uncle George | 1999-07-23 01:52:19 | Re: [PORTS] RedHat6.0 & Alpha |