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