Re: [SQL] How to hand over array as variable in plpgsql function?

"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 p

Fwd: [SQL] grouping/clustering query

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, > > Th

[SQL] How to hand over array as variable in plpgsql function?

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

Re: [SQL] SQL Statement Missing From Log

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, co

[SQL] SQL Statement Missing From Log

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 tr