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 :my
> 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 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
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
---(end of broadcast)---
TIP 3: if posting/reading through Us
