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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
