Re: variables in procedures - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: variables in procedures
Date
Msg-id 20011130093356.A55762-100000@megazone23.bigpanda.com
Whole thread Raw
In response to variables in procedures  (Martín Marqués <martin@bugs.unl.edu.ar>)
List pgsql-sql
On Fri, 30 Nov 2001, [iso-8859-1] Mart�n Marqu�s wrote:

> How can I distinguish between the name and the value of a variable?
>
> Example:
>
> CREATE FUNCTION test(VARCHAR) RETURNS INTEGER AS '
>
> DECLARE
>     col1 ALIAS FOR $1
> BEGIN
>     select col1 from tab where col1=��col1��;
> END;
> � LANGUAGE 'plpgsql';
>
>
> Is my doubt understood?

AFAIK you don't distinguish, you'll probably need to name
the variable something else.



pgsql-sql by date:

Previous
From: Roberto Mello
Date:
Subject: Re: Any available solution to port CONNECT BY of oracle to postgresql
Next
From: "Peter T. Brown"
Date:
Subject: Re: contracting tables