List,

I have a requirement to write a query that lists a set of attribute/value pairs, but the values need to be dynamically created on the fly from another query or function. Is it possible to have a table like this:

Attribute   |   Value
-------------------------
Attrib1     |   select val1, val1 from table;
Attrib2     |   func()

return this:

Attribute   |   Value
-------------------------
Attrib1     |   result1
Attrib2     |   result2

If this is possible? How would I go about it? I'm thinking pl/pgsql and execute() but I'm not sure.

Any thoughts?

schu

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to