First of all thanks for the quick replies, i'll describe my problem more in detail.
I'm using postgress with the latest release of GNU Gatekeeper.
More specifically I need a query that returns a row with exactly a single column (a text) in one case and a row with exactly two columns (a text and an integer) in the other case.
So i can't just return everytime two columns with one null sometimes. I know this is a little strange but it's a constraint of the Gatekeeper so i have no choiche :(
This is the way i call the query from inside the gatekeeper:
select * from routing ( param1, param2, param3, param4 ) as ( result text, reason integer );
is there a way to make the reason optional?
Thanks.
Gianpiero Venditti