Richard Rosenberg <richrosenb...@earthlink.net> writes: > Tom, thanks for your prompt reply. I think I may have my head on straight > now, > this should work:
Yeah, but you're still out of luck on 7.4. Its plpgsql doesn't have any ability to pass whole-row variables into expressions. I don't see any answer for you except breaking down the row into columns, which of course is going to be a huge notational PITA. Sure you can't move the DB off 7.4? There would be pretty considerable benefits from adopting some recent release instead. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql