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
-------------------------------------------------------------------------------
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 |