Hi,
having a small problem in a trigger i want to automatically update a date field but when i use for example
update table set field = current_date where table.pk = new.pk
or
update table set field = now() where table.pk = new.pk
this crashes think link between server and db, i have tried using these commands on a command line and they work ok
thanks for any help again
JD
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org