variables in procedures

From: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: pgsql-sql(at)postgresql(dot)org
Subject: variables in procedures
Date: 2001-11-30 13:43:43
Message-ID: 20011130134344.BED7EFA61@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
BEGIN
select 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(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Brett W. McCoy 2001-11-30 15:04:44 Re: Logging
Previous Message Duncan Adams (DNS) 2001-11-30 12:39:32 Re: [NOVICE] Logging