|
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 |
