variables in procedures - Mailing list pgsql-sql

From Martín Marqués
Subject variables in procedures
Date
Msg-id 20011130134344.BED7EFA61@bugs.unl.edu.ar
Whole thread Raw
Responses Re: variables in procedures  ("Josh Berkus" <josh@agliodbs.com>)
Re: variables in procedures  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
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
BEGINselect col1 from tab where col1=´´col1´´;
END;
´ LANGUAGE 'plpgsql';


Is my doubt understood?

-- 
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica                      Universidad Nacional
        del Litoral
 
-----------------------------------------------------------------


pgsql-sql by date:

Previous
From: Markus Bertheau
Date:
Subject: Re: [NOVICE] Logging
Next
From: Jeff Eckermann
Date:
Subject: Re: contracting tables