Re: dynamic SQL - variable substitution in plpgsql

km wrote:
> Hi all,
>
> i could not do variable substitution in plpgsql procedure.
> The variable names are taken as it is but not substituted in the SQL query.
> what could be the problem ?

Does this example even compile? I doubt that...

> code looks like this:
> ------------------------------------------------------------------
> CREATE OR REPLACE FUNCTION test(a text) RETURNS SETOF RECORD AS $$
> DECLARE
> a  text;
> b  text;

I think you meant:

DECLARE
 b  text;
 c  text;

You redeclared a and never declared c.

> BEGIN
>
> IF a = 'odd' THEN
> b := 10;
> c := 30;
> ELIF a = 'even' THEN
> b := 20;
> c := 40;
> END IF;

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //