function SETOF return type with variable columns?

From: James Neff <james(dot)neff(at)tethyshealth(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: function SETOF return type with variable columns?
Date: 2008-08-20 16:59:34
Message-ID: 48AC4D76.5090105@tethyshealth.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

Is it possible to have a function with a return type of SETOF that has
variable number of return columns?

The input parameter for this function will be a String containing a
number of codes separated by a tilde character. I would like to have 1
output column for each of these codes, but the number of input codes may
change for each time the function is called.

For example:

Input: ABC1~XYZ2~MNO3

Output result set will then look like this where name, ABC1, XYZ2, and
MNO3 are column headers and not a data row:

name | ABC1 | XYZ2 | MNO3
bob | 9 | 3 | 1
john | 5 | 2 | 1
...

Every row in the output set will contain a name and then a count of the
number of codes matched for that name. But the codes queried for would
change with each call of the function.

Does it make sense what I am asking for?

Thanks in advance,
James

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Pettis 2008-08-20 17:38:54 Re: Fwd: Restarting with pg_ctl, users, and passwords.
Previous Message Lennin Caro 2008-08-20 16:12:25 Re: schema name in SQL statement.