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:
> --
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 ?
FOR result IN "SELECT x,y,z FROM mydata WHERE x = a AND y < b AND z > c" LOOP
RETURN NEXT result;
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 ?
code looks like this:
--
CREATE OR REPLACE FUNCTION test(a te
