Re: SELECT INTO broken (?) in PL/pgSQL when using a set returning function in FROM clause (BGUG?)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "ezra epstein" <ee_newsgroup_post(at)prajnait(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SELECT INTO broken (?) in PL/pgSQL when using a set returning function in FROM clause (BGUG?)
Date: 2003-12-25 16:15:21
Message-ID: 20461.1072368921@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"ezra epstein" <ee_newsgroup_post(at)prajnait(dot)com> writes:
> IF NOT EXISTS(SELECT 1 FROM merchandise.ds_item($1) WHERE "client_key" =
> $2) THEN
> [ works, but this doesn't: ]
> SELECT INTO rec * FROM merchandise.ds_item($1) WHERE "client_key" = %2;

If that's an accurate transcription, then your error is using %2 where
you meant $2.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christian Kienle 2003-12-25 22:15:21 Photos of PostgreSQL booth
Previous Message Tom Lane 2003-12-25 16:11:11 Re: Parser does not like %ROWTYPE in the RETURNS clause of a function declaration (BUG?)