Dear Helpful People,
I'm getting a bunch of:
2008-10-25 14:36:59 PDT ERROR: syntax error at or near SET at character 9
2008-10-25 14:36:59 PDT ERROR: syntax error at or near fetch at
character 9
2008-10-25 14:36:59 PDT ERROR: current transaction is aborted, commands
ignored until end of
Bryce Nesbitt [EMAIL PROTECTED] writes:
I'm getting a bunch of:
2008-10-25 14:36:59 PDT ERROR: syntax error at or near SET at character 9
2008-10-25 14:36:59 PDT ERROR: syntax error at or near fetch at
character 9
2008-10-25 14:36:59 PDT ERROR: current transaction is aborted, commands
Dear list,
I am trying to hand over an float4 array of a previous query in my plpgsql
function. The query returns the correct array but when I try to hand over this
array to another function I get the error message:
ERROR: operator is not unique: unknown || real[]
SQL state: 42725
Hint: Could
I forgot the list.
-- Forwarded message --
From: Osvaldo Kussama [EMAIL PROTECTED]
Date: Mon, 27 Oct 2008 12:28:57 -0200
Subject: Re: [SQL] grouping/clustering query
To: David Garamond [EMAIL PROTECTED]
2008/10/24, David Garamond [EMAIL PROTECTED]:
Tony, Joe, Steve,
Thanks for
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