Home > mailing lists

Re: Return num of deleted rows from function - Mailing list pgsql-general

From	Tom Lane
Subject	Re: Return num of deleted rows from function
Date	August 6, 2002 12:56:00
Msg-id	15040.1028642145@sss.pgh.pa.us Whole thread Raw
In response to	Return num of deleted rows from function ("Ben-Nes Michael" <miki@canaan.co.il>)
List	pgsql-general

Tree view

"Ben-Nes Michael" <miki@canaan.co.il> writes:
> How can I RETURN from within a function the number of deleted rows ?

In plpgsql, use GET DIAGNOSTICS - see bottom of
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/plpgsql-statements.html

            regards, tom lane

pgsql-general by date:

From: Moritz Sinn
Date: 06 August 2002, 11:49:47
Subject: psql: exit status

From: J Smith
Date: 06 August 2002, 13:56:13
Subject: Re: Creating GiST Indices?

Re: Return num of deleted rows from function - Mailing list pgsql-general

Previous

Next