Hi,
Is there a way to specify a local variable/parameter within a query
where a column has the same name than the local variable/parameter?
Example:
CREATE OR REPLACE FUNCTION foo(i IN int)
RETURNS void
AS $$
BEGIN
UPDATE bar
SET i = i; // column i = parameter i
END;
$$ LANGUAGE PLPGSQL;
For instance, Ingres suggests prefixing local variable/parameter with
":" in the query:
UPDATE bar
SET i = :i;
I can continue using the de facto Oracle's naming convention
(P_parameter and V_local_variable) anyway. That's not a big deal.
Regards,
--
Daniel CAUNE
Ubisoft Online Technology
(514) 490 2040 ext. 3613
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
