From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Poul Jensen <flyvholm(at)gfy(dot)ku(dot)dk> |
Cc: | Joachim Wieland <joe(at)mcknight(dot)de>, pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: ECPG: non-integer constant in group by |
Date: | 2006-09-16 09:24:55 |
Message-ID: | 20060916092455.GA19244@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Sep 15, 2006 at 02:44:33PM -0800, Poul Jensen wrote:
> The other problem I posted is worse and is what's really keeping me
> stuck. Why are my text strings considered unacceptable "non-integer
> constants"? Here are the relevant lines of code:
<snip>
That's because your query is expanding to:
SELECT 'filenm' FROM beamdata GROUP BY 'filenm';
Which is probably not what you're looking for. The reason postgres is
complaining is because grouping by a constant doesn't make any sense.
Integer constants are special-cased to mean column numbers, hence the
reference to non-integer constants.
Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
From | Date | Subject | |
---|---|---|---|
Next Message | Poul Jensen | 2006-09-16 11:47:28 | Re: ECPG: non-integer constant in group by |
Previous Message | Francisco Reyes | 2006-09-16 06:03:34 | Re: Superuser lost access to particular database |