Re: [GENERAL] Problems with date configuration

2006-09-21 Thread Jim Nasby
On Sep 13, 2006, at 10:39 AM, Fabi Avilés wrote: Hi, I had an application in which I used postgres 7.4, and then only thing refering to date was: datestyle = 'ISO,European' everything else was commented. Now I have had to change the OS and I've installed postgres 8.1.3, but this config

Re: [GENERAL] problems with date

2004-12-21 Thread Richard Huxton
Jamie Deppeler wrote: 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 If "table" is the table with the trigger on it, you'll end up with an endless loop, since the trigger