On Freitag, 20. Juni 2008, Gregory Williamson wrote:
| For reasons best left unmentioned, I need to update entries in a table from
| a backup; I need to do all entries.
|
| For reasons eluding my sleep deprived eyes this fails in every variation I
| can think of:
|
| update foo set foo.foo_name2=fo
Thomas Pundt wrote:
>
> On Freitag, 20. Juni 2008, Gregory Williamson wrote:
<...snip...>
> Does
>
> update foo
>set foo.foo_name2 = foo_old.foo_name2
> from foo_old
> where foo.foo_id = foo_old.foo_id;
>
> work for you?
Thanks to all for pointing out the FROM clause.!
"UPDATE foo se
ailto:[EMAIL PROTECTED] Im Auftrag von Gregory
Williamson
Gesendet: Freitag, 20. Juni 2008 12:30
An: pgsql-general@postgresql.org
Betreff: [GENERAL] Need to update all entries of one table based on an
earlier backup
For reasons best left unmentioned, I
For reasons best left unmentioned, I need to update entries in a table from a
backup; I need to do all entries.
For reasons eluding my sleep deprived eyes this fails in every variation I can
think of:
update foo set foo.foo_name2=foo_old.foo_name2 where foo.foo_id =
foo_old.foo_id;
ERROR: mis
