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
                                          

Reply via email to