Re: [GENERAL] psql internal variables

2006-08-07 Thread Peter Eisentraut
Thor Tall wrote: > If I just delete from table_a and then table_b and the > table_c I may risk deleting rows in table_b and > table_c which correspond to rows in table_a. (due to > the different times returned by now(); now() returns a constant value in a transaction. -- Peter Eisentraut http://

[GENERAL] psql internal variables

2006-08-07 Thread Thor Tall
Hi, It looks as if psql has internal variables I am how ever not able to get it to work in the way I want. I need to store the current date and then delete all elements from 3 tables based on the same date. I tried to set the variable curtime: set curtime now() but I could not use it in a dele