Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: SELECT INTO broken (?) in PL/pgSQL when using a set returning function in FROM clause (BGUG?)
Date
Msg-id 20461.1072368921@sss.pgh.pa.us
Whole thread Raw
In response to SELECT INTO broken (?) in PL/pgSQL when using a set returning function in FROM clause (BGUG?)  ("ezra epstein" <ee_newsgroup_post@prajnait.com>)
List pgsql-general
Tree view 
"ezra epstein" <ee_newsgroup_post@prajnait.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Parser does not like %ROWTYPE in the RETURNS clause of a function declaration (BUG?)
Next
From: Christian Kienle
Date:
Subject: Photos of PostgreSQL booth