Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1KGt6x29324 for ; Tue, 20 Feb 2001 11:55:06 -0500 (EST) (envelope-from josh@agliodbs.com) Received: from [207.172.28.154] (HELO agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.3) with ESMTP id 1192769; Tue, 20 Feb 2001 08:54:58 -0800 Message-ID: <3A92A15E.1E7DF00D@agliodbs.com> Date: Tue, 20 Feb 2001 08:54:54 -0800 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions X-Mailer: Mozilla 4.73 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: sqllist CC: Jeff MacDonald Subject: Huh? Mysterious Function Error Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/311 X-Sequence-Number: 1507 Tom, Stephan, Jan, Etc. Can you help me with this one? I can't figure out what is meant by this error message: I have a long, complicated PL/pgSQL function called fn_modify_candidates(INT4,INT4,INT4). When I call: SELECT fn_modify_candidate(1004,5,278417036) I get: ERROR: unexpected SELECT query in exec_stmt_execsql() Help? -Josh Berkus -- ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco