Re: [SQL] interval +variable

2005-03-10 Thread AL� �EL�K
+ '1 days'::interval ""Fatih Cerit"" <[EMAIL PROTECTED]>, haber iletisinde þunlarý yazdý:[EMAIL PROTECTED] > Dear all > > Is there anyone at there who knows howto use dateadd in pgsql. I have a > problem in my function that is like this ; > > Select into futuredate now() + interval '30 days'; <

[SQL] best way to auto-update a field when row is updated

2005-03-10 Thread Henry Ortega
I have the following table FIELD_A| FIELD_B | TSTAMP x y 2005-03-10 14:56:47.456431 TSTAMP = not null

Re: [SQL] best way to auto-update a field when row is updated

2005-03-10 Thread Larry Rosenman
On Thursday 10 March 2005 02:09 pm, Henry Ortega wrote: > I have the following table > > FIELD_A| FIELD_B | TSTAMP > --- >- x y

Re: [SQL] best way to auto-update a field when row is updated

2005-03-10 Thread Scott Marlowe
On Thu, 2005-03-10 at 14:09, Henry Ortega wrote: > I have the following table > > FIELD_A| FIELD_B | TSTAMP > > x y