Minor change for UPDATE

From: Daniele Orlandi <daniele(at)orlandi(dot)com>
To: hackers(at)postgreSQL(dot)org
Subject: Minor change for UPDATE
Date: 1999-02-03 16:36:43
Message-ID: 36B87B1B.6A7C783A@orlandi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hi,

I sometimes need to update records without a SET clause, just to fire a trigger
that actually changes the tuple.

Currently I do:

UPDATE relation SET anyfield=anyfield WHERE whereclause;

It would be nice to be able to do:

UPDATE relation WHERE whereclause;

I don't know if this will break something, and I'd like to make the change
myself, but I'm still a newbie in the postgres internals. Please consider it a
lowest-priority entry to be put in the whis-list :^)

Thanks!

Bye!

--
Daniele

-------------------------------------------------------------------------------
Daniele Orlandi - Utility Line Italia - http://www.orlandi.com
Via Mezzera 29/A - 20030 - Seveso (MI) - Italy
-------------------------------------------------------------------------------

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-02-03 16:53:58 Re: [HACKERS] template/alpha_cc
Previous Message The Hermit Hacker 1999-02-03 15:38:19 Re: [HACKERS] 6.5 beta and ORDER BY patch