Re: Postgres function with output parameters and resultset

2018-07-20 Thread Adrian Klaver
On 07/20/2018 02:19 PM, Arulalan Narayanasamy wrote: Hi, I need to create a function which should return resultset and output parameters. For example, I need to retrieve all the records from EMP table whose Grade is 'A' as resultset and total number of matched records, Success or Failure flag

Re: Postgres function with output parameters and resultset

2018-07-20 Thread David G. Johnston
On Friday, July 20, 2018, Arulalan Narayanasamy < arulalan.narayanas...@gmail.com> wrote: > Hi, > I need to create a function which should return resultset and output > parameters. For example, I need to retrieve all the records from EMP table > whose Grade is 'A' as resultset and total number of

Postgres function with output parameters and resultset

2018-07-20 Thread Arulalan Narayanasamy
Hi, I need to create a function which should return resultset and output parameters. For example, I need to retrieve all the records from EMP table whose Grade is 'A' as resultset and total number of matched records, Success or Failure flag & Error message as output parameters. Is there a way in Po