[SQL] SQL Statement Missing From Log

2008-10-27 Thread Bryce Nesbitt
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

Re: [SQL] SQL Statement Missing From Log

2008-10-27 Thread Tom Lane
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

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

2008-10-27 Thread Jan Peters
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

Fwd: [SQL] grouping/clustering query

2008-10-27 Thread Osvaldo Kussama
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

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

2008-10-27 Thread Tom Lane
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