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 [EMAIL PROTECTED] 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
