Hello everybody,
I am using PostgresSQL in Linux, and I want to declare a user variable so that I can use its value
for new queries after giving it a value.
While using WinNT and SQL Server I was writting (for example ):
declare @@task_id int
selct @@task_id = id from task were name ='Mytask'
update task set final='N' where id = @@task_id
But when I write these sentences in Postgres for Linux (I am using RedHat 6.0), I am told:
"ERROR: parser: parse error at or near @@"
How can I do the same?
Thank you very much,
Rosa
--------------------------------------
Rosa Maria Carro Salas
E.T.S.Informatica
Universidad Autonoma de Madrid
Cantoblanco 28049, Madrid (Spain)
phone: +34 1 348 2291