Thread: user defined variable per session

Hello,

I need to create user defined variable in every database session.
In Sybase ASA is equivalent:
CREATE VARIABLE name TYPE;

I need use this in views. Is it possible???

thanx, miso

On Sunday, December 7, 2003, at 11:38 PM, Miso Hlavac wrote:

> Hello,
>
> I need to create user defined variable in every database session.
> In Sybase ASA is equivalent:
> CREATE VARIABLE name TYPE;
>
> I need use this in views. Is it possible???

Would it be possible to use a temp (very simple) temp table to do this?
For example

CREATE TEMP TABLE variable (value INT);

for an integer variable. Then just use UPDATE and SELECT to set and
return the variable.

Michael
grzm myrealbox com

> I need to create user defined variable in every database session.
> In Sybase ASA is equivalent:
> CREATE VARIABLE name TYPE;
>
> I need use this in views. Is it possible???

What about

test=> \set myvar 5
test=> select :myvar;
 ?column?
----------
        5
(1 row)

hth
cl.

On Sun, 2003-12-07 at 19:57, Claudio Lapidus wrote:
> > I need to create user defined variable in every database session.
> > In Sybase ASA is equivalent:
> > CREATE VARIABLE name TYPE;
> >
> > I need use this in views. Is it possible???
>
> What about
>
> test=> \set myvar 5
> test=> select :myvar;
>  ?column?
> ----------
>         5
> (1 row)

But that is specific to psql.  It's not something you can use in an
application, as you might the Sybase command.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "And if thy hand offend thee, cut it off; it is better
      for thee to enter into life maimed, than having two
      hands to go into hell, into the fire that never shall
      be quenched."                Mark 9:43