Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Sql > function return...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 11 Topic 3491 of 3799
Post > Topic >>

function returning result set of varying column

by psmg01@[EMAIL PROTECTED] ("maria s") Jun 2, 2008 at 04:40 PM

------=_Part_256_24965745.1212439249442
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi friends,
I am very new to plsql.

I have to write a function that quries few tables and  returns a resultset
of varying column.

 In that case I cannot predefine the table with column.
If I use RETURNS SETOF then I should know the number of columns and its
type?!

Is there anyway to return a resultset with any number of column?

Thanks for your help.

-maria

------=_Part_256_24965745.1212439249442
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi friends,<br>I am very new to plsql.<br><br>I have to write a function
that quries few tables and&nbsp; returns a resultset of varying column.
<br><br>&nbsp;In that case I cannot predefine the table with column.
<br>If I use RETURNS SETOF then I should know the number of columns and
its type?! <br>
<br>Is there anyway to return a resultset with any number of
column?<br><br>Thanks for your help.<br><br>-maria<br>

------=_Part_256_24965745.1212439249442--
 




 11 Posts in Topic:
function returning result set of varying column
psmg01@[EMAIL PROTECTED]   2008-06-02 16:40:48 
Re: function returning result set of varying column
Bart.Degryse@[EMAIL PROTE  2008-06-03 09:06:29 
Re: function returning result set of varying column
psmg01@[EMAIL PROTECTED]   2008-06-03 09:01:02 
Re: function returning result set of varying column
mail@[EMAIL PROTECTED] (  2008-06-03 15:28:41 
Re: function returning result set of varying column
psmg01@[EMAIL PROTECTED]   2008-06-03 09:41:27 
Re: function returning result set of varying column
pavel.stehule@[EMAIL PROT  2008-06-03 15:54:41 
Re: function returning result set of varying column
mail@[EMAIL PROTECTED] (  2008-06-03 15:57:45 
Re: function returning result set of varying column
psmg01@[EMAIL PROTECTED]   2008-06-03 10:06:45 
Re: function returning result set of varying column
psmg01@[EMAIL PROTECTED]   2008-06-03 11:06:02 
Re: function returning result set of varying column
mail@[EMAIL PROTECTED] (  2008-06-03 17:17:48 
Re: function returning result set of varying column
pavel.stehule@[EMAIL PROT  2008-06-03 18:14:44 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 21:51:02 CST 2008.