Parsing bug?

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: pgsql-general(at)postgresql(dot)org (pgsql general list)
Subject: Parsing bug?
Date: 2004-01-23 00:18:30
Message-ID: 200401230018.i0N0IVjq024584@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In the following query the field 'memid' is varchar(8).

Is the error message below a bug?

select substr(memid,1,1) as memtp, substr(memid,2,4) as newx
from memmast group by memtp, newx

ERROR: column "memmast.memid" must appear in the GROUP BY clause or be used in
an aggregate function
--
Mike Nolan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reece Hart 2004-01-23 00:40:39 Re: psql: relocation error: psql: undefined symbol:
Previous Message Phil Campaigne 2004-01-23 00:13:48 psql: relocation error: psql: undefined symbol: PQgetssl