Request a Demo
Home   >   mailing lists

Like to RETURN SQL results set - Mailing list pgsql-admin

From M Sarwar
Subject Like to RETURN SQL results set
Date
Msg-id DM4PR19MB5978E0422300C922982974EBD3342@DM4PR19MB5978.namprd19.prod.outlook.com
Whole thread Raw
Responses Re: Like to RETURN SQL results set
List pgsql-admin
Tree view
 

 

Hello,

 

I am writing a dynamic function in which number of columns to be retrieved change depending on the parameter values passed while invoking the function. I am using CROSSTAB in the dynamic SQL.

Once I prepare a dynamic SQL and I execute, I want the entire result set from the executed SQL to be returned to function RETURN.

Is this possible? If yes, can you please point me to some examples.

 

Thanks,

Sarwar

 

pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: upgrade from centos 6.8 to 6.10
Next
From: Laurenz Albe
Date:
Subject: Re: Like to RETURN SQL results set