Re: Finding the number of rows affected by UPDATE or INSERT?
От | Joe Conway |
---|---|
Тема | Re: Finding the number of rows affected by UPDATE or INSERT? |
Дата | |
Msg-id | 00d001c1311e$1a5fa420$0705a8c0@jecw2k1 обсуждение исходный текст |
Ответ на | Finding the number of rows affected by UPDATE or INSERT? ("Dr. Evil" <drevil@sidereal.kz>) |
Список | pgsql-general |
> I am writing a bunch of stuff in pl/pgsql, and some of these functions > do UPDATEs or INSERTs on various tables. How could I find out, from > within the pl/pgsql function, how many rows were affected? This way, > if the update or insert fails for some reason, I can return a "failed" > message from the function, instead of pretending that everything is > ok. I think you want GET DIAGNOSTICS. See http://www.postgresql.org/idocs/index.php?plpgsql-description.html Here's the relevant section: 24.2.5.4. Obtaining other results status GET DIAGNOSTICS variable = item [ , ... ] This command allows retrieval of system status indicators. Each item is a keyword identifying a state value to be assigned to the specified variable (which should be of the right datatype to receive it). The currently available status items are ROW_COUNT, the number of rows processed by the last SQL query sent down to the SQL engine; and RESULT_OID, the Oid of the last row inserted by the most recent SQL query. Note that RESULT_OID is only useful after an INSERT query. HTH, -- Joe
В списке pgsql-general по дате отправления: