| From: | "Chad Wagner" <chad(dot)wagner(at)gmail(dot)com> |
|---|---|
| To: | "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, Chris <dmagick(at)gmail(dot)com>, "Chad Wagner" <chad(dot)wagner(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: postgresql vs mysql |
| Date: | 2007-02-22 17:49:16 |
| Message-ID: | 81961ff50702220949l9619d8ao2f4ce8005f6b3175@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2/22/07, Martijn van Oosterhout <kleptog(at)svana(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joris Dobbelsteen | 2007-02-22 17:51:49 | Re: complex referential integrity constraints |
| Previous Message | Ron Johnson | 2007-02-22 17:40:43 | Re: php professional |