avoid replace of column with variable in pgsql function

From: Gerhard Heift <ml-postgresql-20081012-3518(at)gheift(dot)de>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: avoid replace of column with variable in pgsql function
Date: 2008-11-16 23:35:50
Message-ID: 20081116233550.GA19294@toaster.kawo1.rwth-aachen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have a function with an out variable in which I have an INSERT
statement with the same name as column. Is it possible to avoid the
replacement?

Its something like this:

CREATE FUNCTION insert_foo(IN bar integer, OUT id integer) AS
$BODY$
BEGIN
INSERT INTO t1 (id, value) VALUES (bar, bar || '-bar');
SELECT foo INTO id FROM t2 WHERE value = bar;
END
$BODY$ LANGUAGE 'plpgsql';

In the INSERT statemet the id column is replaced with $2, which is not
what I want. Quoting the colum name does not help. And I dont want to
rename the output variable nor the column of the table.

Is this possible?

Regards,
Gerhard

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-11-16 23:49:11 Re: avoid replace of column with variable in pgsql function
Previous Message Garry Saddington 2008-11-16 17:39:52 aggregates and case statements