Thread: return data before the update

Hi all,
Is it possible to perform an update and return the old data, i.e., the data updated? Do I need a store procedure?
I'm trying to perform this operation using JDBC, but I can't find a solution for this problem.
 
Kind regards,
LS

---

Hotmail: Powerful Free email with security by Microsoft. Get it now.

Luis Silva <lfs12@hotmail.com> wrote:

> Hi all,
> Is it possible to perform an update and return the old data, i.e., the data
> updated? Do I need a store procedure?

What do you want to do with the old data? Store i a other table (like a
log-table)?

I think, you needs a TRIGGER, and the TRIGGER has to store the old
values in your log-table.

Do you know tablelog?
http://andreas.scherbaum.la/blog/archives/100-Log-Table-Changes-in-PostgreSQL-with-tablelog.html


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

Thanks for the quick replay.
I wanted to return it when doing the update query.

> Date: Sat, 9 Jan 2010 07:47:32 +0100
> From: akretschmer@spamfence.net
> To: pgsql-novice@postgresql.org
> Subject: Re: [NOVICE] return data before the update
>
> Luis Silva <lfs12@hotmail.com> wrote:
>
> > Hi all,
> > Is it possible to perform an update and return the old data, i.e., the data
> > updated? Do I need a store procedure?
>
> What do you want to do with the old data? Store i a other table (like a
> log-table)?
>
> I think, you needs a TRIGGER, and the TRIGGER has to store the old
> values in your log-table.
>
> Do you know tablelog?
> http://andreas.scherbaum.la/blog/archives/100-Log-Table-Changes-in-PostgreSQL-with-tablelog.html
>
>
> Andreas
> --
> Really, I'm not out to destroy Microsoft. That will just be a completely
> unintentional side effect. (Linus Torvalds)
> "If I was god, I would recompile penguin with --enable-fly." (unknown)
> Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice

---

Hotmail: Free, trusted and rich email service. Get it now.