What would be the correct way to set up a dynamic
variable? I did some further research on my question
below, and I still don't have a definite answer to
whether or not use \set or SET. I did read at
http://www.commandprompt.com/ppbook/x19832 about using
variables in a Function, but that seems like an awful
lot to do [or does MS SQL make it easier than
PostgreSQL?]. Any help, ideas, or clarification are
much appreciated.


--- Ubence Quevedo wrote:
Date: Thu, 29 Dec 2005 15:26:07 -0800 (PST)
From: Ubence Quevedo <r0d3nt@pacbell.net>
Subject: Simple Accumulating Number Loop?
To: pgsql-novice@postgresql.org,

A friend of mine has created this simple
loop query for MS SQL 2k5 Express Edition. I am
trying to reproduce the same results with PostgreSQL
8.1, but am not able to find much useful help on how
to properly set up a variable of both int and char.
The PostgreSQL documentation is great if you have an
idea of what you are doing, but I'm still really new
to PostgreSQL. If someone can just point out some
hints or clarifications as to wether to use the SET
command or the psql \set command. Below is the
in question.

Many thanx to any that can help.


declare @variableint int
declare @desc char (50)
set @variableint = 0
create table counter (countid int , description
while @variableint < 500
set @variableint = @variableint + 1
set @desc = 'The Counter is Now' +' '+ cast
(@variableint as char(50))
insert into counter values (@variableint,@desc)
select * from counter

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
postedDec 30, '05 at 9:52p
activeDec 30, '05 at 9:52p

1 user in discussion

Ubence Quevedo: 1 post



site design / logo © 2022 Grokbase