Re: Huh? Mysterious Function Error

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: sqllist <pgsql-sql(at)postgresql(dot)org>, Jeff MacDonald <jeff(at)pgsql(dot)com>
Subject: Re: Huh? Mysterious Function Error
Date: 2001-02-20 17:48:42
Message-ID: Pine.BSF.4.21.0102200944290.3180-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Does the function have any SELECTs that aren't
SELECT INTOs?

On Tue, 20 Feb 2001, Josh Berkus wrote:

> 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?

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-02-20 17:58:09 Re: Huh? Mysterious Function Error
Previous Message Tom Lane 2001-02-20 17:36:52 Re: Huh? Mysterious Function Error