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@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.