"Jan Peters" <[EMAIL PROTECTED]> writes:
> ERROR: operator is not unique: "unknown" || real[]
> EXECUTE 'SELECT id FROM precip_arrays WHERE '||b||' = precip_control;' INTO
> id_result;
Seems like using EXECUTE is the hardest possible way to do this. Why
don't you just SELECT?
SELECT id FROM precip_arrays WHERE b = precip_control INTO id_result;
If you insist on using EXECUTE then you're going to have to fool with
converting the array to an appropriate text representation.
regards, tom lane
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
