Skip site navigation (1) Skip section navigation (2)

returning array from function or "structured error"

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: <pgsql-general(at)postgresql(dot)org>
Subject: returning array from function or "structured error"
Date: 2008-03-30 20:38:03
Message-ID: 20080330223803.46db3bee@webthatworks.it (view raw or flat)
Thread:
Lists: pgsql-general
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
building up a bitmap look awful.

Any elegant idea?

thx

-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it


Responses

pgsql-general by date

Next:From: Vismaster46Date: 2008-03-30 21:12:37
Subject: PostgreSQL and Java on WindowsXP
Previous:From: Tom LaneDate: 2008-03-30 20:28:24
Subject: Re: database 1.2G, pg_dump 73M?!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group