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
> --- Ubence Quevedo <[EMAIL PROTECTED]> wrote:
>
> > Date: Thu, 29 Dec 2005 15:26:07 -0800 (PST)
> > From: Ubence Quevedo <[EMAIL PROTECTED]>
> > Subject: Simple Accumulating Number Loop?
> > To: [EMAIL PROTECTED],
> > pgsql-general@postgresql.org
> >
> > A friend of mine has created this simple
> > accumulating
> > 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
> > query
> > in question.
> >
> > Many thanx to any that can help.
> >
> > -Ubence
> >
> > declare @variableint int
> > declare @desc char (50)
> > set @variableint = 0
> > create table counter (countid int , description
> > varchar(50))
> > while @variableint < 500
> > begin
> > set @variableint = @variableint + 1
> > set @desc = 'The Counter is Now' +' '+ cast
> > (@variableint as char(50))
> > insert into counter values (@variableint,@desc)
> > end
> > select * from counter
> >
>
>
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
