Re: [GENERAL] returning array from function or "structured error"

2008-03-30 Thread Craig Ringer
Ivan Sergio Borgonovo wrote: Building up a temp table and returning a "setof record" You can avoid the temp table and return `setof record'. Just `RETURN NEXT temp_result' after each test, where temp_result is your declared working variable. When you're done with all tests, do the final RETURN.

[GENERAL] returning array from function or "structured error"

2008-03-30 Thread Ivan Sergio Borgonovo
I've a plpgsql function that execute some tests on data and it has to return which test failed. It would be handy to return an array... but an array is returned as a serialised object and I'd like to avoid to un-serialise it from php. Building up a temp table and returning a "setof record" or bui