Folks, While using DBI-Link, I've noticed a little lacuna in how functions returning (SETOF) RECORD work, namely, that you have to cast them to explicit lists of columns, even when that list of columns corresponds to an existing complex type.
What would be involved in fixing the casting operation so that the following would work? CREATE TYPE foo AS ( a INT4, b INT8, c POINT, d TEXT ); CREATE FUNCTION bar(output_type TEXT) RETURNS SETOF RECORD ... SELECT * FROM bar('foo') AS foo; Cheers, D -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend