From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Walter Cruz <walter.php@gmail.com>
Cc: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: help with pagila
Date: Fri, 01 Sep 2006 14:58:58 -0500
Message-ID: <1157140737.4786.31.camel@state.g2switchworks.com> (raw)
In-Reply-To: <32cabba0609011026r6616a73bhe80b336f18aa84ac@mail.gmail.com>
References: <32cabba0609010631t233d13f9o38edba0483a2446c@mail.gmail.com>
<20060901152116.GE17178@phlogiston.dyndns.org>
<32cabba0609011026r6616a73bhe80b336f18aa84ac@mail.gmail.com>
On Fri, 2006-09-01 at 12:26, Walter Cruz wrote:
> So I can assume that the MySQL implementation is strange? (It accepts
> that kind of query)
Yes, according to the SQL spec, you should generally get an error when
you run a query like this:
select field1, field2 from table group by field1
since you could theoretically get a different value for field2 each time
you run the query. If the data looked like this:
field1 | field2
-------+--------
1 | 1
1 | 3
2 | 5
2 | 3
The possible answers to that query would be (1,1)(2,5), (1,1)(2,3),
(1,3)(2,5), (1,3)(2,3)
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: smarlowe@g2switchworks.com, walter.php@gmail.com, ajs@crankycanuck.ca
Subject: Re: help with pagila
In-Reply-To: <1157140737.4786.31.camel@state.g2switchworks.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