Postgres Pro
Downloads
Home   >   mailing lists

Re: postgresql vs mysql - Mailing list pgsql-general

From Chad Wagner
Subject Re: postgresql vs mysql
Date
Msg-id 81961ff50702220949l9619d8ao2f4ce8005f6b3175@mail.gmail.com
Whole thread Raw
In response to Re: postgresql vs mysql  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view
On 2/22/07, Martijn van Oosterhout <kleptog@svana.org> wrote:
On Thu, Feb 22, 2007 at 12:05:20PM +1100, Chris wrote:
> >SELECT foo, bar, COUNT(*)
> >FROM baz
> >GROUP BY foo

> That one actually comes in handy ;) Especially in older versions (4.0)
> that don't support subselects..

I must say I don't see any reasonable way of interpreting the above
query. Is the value of bar selected randomly?

The value of bar happens to be the first value fetched based on the GROUP BY of foo, not sure how predictable and repeatable it is.

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: php professional
Next
From: "Joris Dobbelsteen"
Date:
Subject: Re: complex referential integrity constraints