Dear list, I wrote a function that takes one parameter of a certain 'table type':
CREATE FUNCTION deserialize(serTable table1) RETURNS record AS ... I whish to use this function in a query such as: SELECT deser.* FROM deserialize(table1) deser(col1 integer, col2 integer), table1 WHERE table1.field > [some_value] Thus: have the function perform its operation on a SUBSET of table1, RETURNING multiple fields. I can't quite figure out how to put this together (other than passing the table name and where-clause as TEXT)... Any ideas? They are very much appreciated. Regards, Rob
