> 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.