On Thu, 17 Jul 2003, Derrick Betts wrote: > I want to get a set of values returned from a function. The values > (there will need to be four of them) come from 4 separate SELECT > statements inside the Function. For example SELECT one INTO variable1 > from table1 where ... then SELECT two INTO variable2 from table1 > where... At first you might think I could just combine the select > statements into one statement, but I can't. I need to pass the > results of each separate select statement into distinct variables and > return them together to the application.
I'd suggest reading one of the items on the set returning functions: http://www.varlena.com/GeneralBits/26.html http://techdocs.postgresql.org/guides/SetReturningFunctions ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
