Hiya - I'm trying to write a stored procedure for pgsql returning results from multiple rows and multiple columns. I'd ordinarly just do a union but the various column types are not all one type. Does anyone have a way to do this? If there is no other way then I guess I just have to retrieve the results via the application layer in PHP -

any help with this would be greatly appreciated.