Postgres Pro
Downloads
Home   >   mailing lists

Re: Questions about writing functions... - Mailing list pgsql-novice

From Tom Lane
Subject Re: Questions about writing functions...
Date
Msg-id 22896.987718247@sss.pgh.pa.us
Whole thread Raw
In response to Questions about writing functions...  ("Bob Whitehouse" <bwhitehouse@geeknest.com>)
List pgsql-novice
Tree view 
"Bob Whitehouse" <bwhitehouse@geeknest.com> writes:
> If I write a function that deletes a record from a table, how do I access
> the output from the delete operation to see if it completed successfully?

In 7.1 you could look at the ROW_COUNT statistic field to see how many
rows were deleted.  I don't think pre-7.1 plpgsql has a way to do that.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Bob Whitehouse"
Date:
Subject: Questions about functions...
Next
From: Shay Moreno
Date:
Subject: Re: Questions about writing functions...