Still no luck... To clarify a bit, take this example:
CREATE OR REPLACE FUNCTION transpose()
RETURNS record AS
$BODY$ DECLARE
output RECORD;
BEGIN
SELECT * INTO output FROM (VALUES(1,2)) as tbl(first,second);
RETURN output;
END;$BODY$
LANGUAGE 'plpgsql' STABLE
COST 100;
Now, I expect to have 2 columns; named "first" and "second". However, like posted before, the flowing query:
SELECT * FROM deserialize();
produces only ONE column (in one row, as one would clearly expect from the function's defnition):
deserialize
-----------
(1,2)
(1 row)
-----------
(1,2)
(1 row)
Any thoughts on how to make sure multiple columns are returned; without specifying this in the function's prototype return clause?
Thanks,
Rob
2009/9/25 Alban Hertroys <dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
On 25 Sep 2009, at 18:34, InterRob wrote:I'm not entirely sure about the syntax in your case, but I think you're looking for:
Unfortunately, this results in ONE row, with ONE column. E.g.:
MYDB=# select * from (SELECT deserialize(kvp) FROM kvp) ss;
deserialize
-----------
(1,2)
(1 row)
I guess I am seeking to prototype the anonymous row layout in the above SQL statement?
MYDB=# select * from (SELECT deserialize(kvp) FROM kvp) ss (a int, b int);
If that doesn't work, it's based on how you normally select from a record-returning function, namely:
MYDB=# SELECT * FROM deserialize('some string') AS ss (a int, b int);
You may need to call it like this though:
MYDB=# select * from (SELECT (deserialize(kvp)).a, (deserialize(kvp)).b FROM kvp) ss (a int, b int);
In that case your function better not be volatile or it will be evaluated twice.
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.
!DSPAM:968,4abd04cd11681949045486!
