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
Ol************@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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org