In response to Richard Sickler :
> > I am not sure if there is a very simple way of doing this?
> >
> > Or, do I need to create a function and a trigger to call the row and
> update
> > with new data and set the last_modified to current_date?
>
> Yes, that's the way, a TRIG
On Monday 22 March 2010 10:55:36 am Chris Barnes wrote:
> I see examples for updating tables using a function, but I would like to
> pull the row requested and modify the last_modified column with
> current_date and push the modified data back into the same row.
>
>
>
> I did see an example of how
KEY (PRICE_DATE,ID));
Any help would be appreciated.
Cheers,
Chris
> Date: Mon, 22 Mar 2010 18:14:00 +0100
> From: andreas.kretsch...@schollglas.com
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Create a function that updates the record with and
> timestamps
&
In response to Chris Barnes :
> I would like to have postgres update the last_modified column with the
> current_date on an update of the record.
>
> I am not sure if there is a very simple way of doing this?
>
> Or, do I need to create a function and a trigger to call the row and update
> with
