variables outside of functions

From: "Ketema J(dot) Harris" <ketema(at)ketema(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: variables outside of functions
Date: 2006-01-31 20:52:37
Message-ID: CEC4D037-DE18-465D-9D75-F965ADE9D543@ketema.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Is it possible to write a block of sql statements that utilize
variables? I can use variables easy enough inside of a function, but
I was attempting to do something very transactSQL like and kepte
running into problems. I would like to do something similar to:

declare
var1 int;
var2 int;
var3 int;

begin
var3 = var1 + var2;
select var3 as addition;
end

is this possible? Thanks.

Ketema J. Harris
www.ketema.net
ketema(at)ketema(dot)net

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message kynn 2006-01-31 21:10:47 How to GRANT SELECT on all tables?
Previous Message Darren R 2006-01-31 19:56:01 subscribe-digest