Postgres Pro
Downloads
Home   >   mailing lists

Parsing bug? - Mailing list pgsql-general

From Mike Nolan
Subject Parsing bug?
Date
Msg-id 200401230018.i0N0IVjq024584@gw.tssi.com
Whole thread Raw
Responses Re: Parsing bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Rick Gigger"
Date:
Subject: Re: embedded/"serverless" (Re: serverless postgresql)
Next
From: Phil Campaigne
Date:
Subject: psql: relocation error: psql: undefined symbol: PQgetssl