Re: Getting actual number of rows updated
От | Patrick.FICHE@AQSACOM.COM |
---|---|
Тема | Re: Getting actual number of rows updated |
Дата | |
Msg-id | 1DC6C8C88D09D51181A40002A5286929B235AB@intranet обсуждение исходный текст |
Ответ на | Getting actual number of rows updated (CSN <cool_screen_name90001@yahoo.com>) |
Список | pgsql-general |
All the raws are updated if there is no WHERE clause. If you want the UPADATED rows, just specify the WHERE clause and it will really improve your performance... EX : UPDATE itemp SET name = replace( name, 'abc', 'def' ) WHERE name LIKE '%abc%' ---------------------------------------------------------------------------- --------------- Patrick Fiche email : patrick.fiche@aqsacom.com tél : 01 69 29 36 18 ---------------------------------------------------------------------------- --------------- -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]On Behalf Of CSN Sent: lundi 8 août 2005 09:33 To: pgsql-general@postgresql.org Subject: [GENERAL] Getting actual number of rows updated Is it possible to have PG report the actual number of rows that actually CHANGED in an update command? e.g. UPDATE items set name=replace(name,'abc','def'); UPDATE 9000 -- Actually only 3 were changed rather than update reporting all rows have been "updated"? Thanks, CSN ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
В списке pgsql-general по дате отправления: