On 08/02/11 12:29 AM, Gianpiero Venditti wrote:
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?
that should be two separate queries.
"select *" shouldn't really be made from application code in the first
place, its a convenience when you're manually querying something, but
queries from a program should name the fields they expect so they aren't
dependent on the table definition and field order.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
