Re: SQL query help?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: John McGough <goff(at)funkster(dot)org(dot)uk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL query help?
Date: 2005-03-08 07:06:02
Message-ID: 20050308070602.GA53394@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Mar 07, 2005 at 04:22:15PM -0000, John McGough wrote:

> +---+-------+--------+---------+----------+
> | ID | JobID | UserID | Finished | Comment |
> +---+-------+--------+---------+----------+

This table output doesn't look like PostgreSQL's usual format.

> but I keep getting MySQL error #1111 - Invalid use of group function

And this error definitely doesn't look like something from PostgreSQL.
Are you sure you're asking the right list?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Sim Zacks 2005-03-08 07:29:37 group by before and after date
Previous Message Igor Kryltsov 2005-03-08 04:47:57 Update PostgreSQL from MS SQL trigger