Message-ID: <4A8D6912.60207@fmed.uba.ar>
Date: Thu, 20 Aug 2009 12:17:38 -0300
From: Gerardo Herzig <gherzig@fmed.uba.ar>
User-Agent: Thunderbird 2.0.0.6 (X11/20070801)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: using case to select 'which version to use'
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi all. I have 2 functions , which returns the same columns, but with
tottaly different logics. I want to wrap it with a third function, who
will receive a boolean argument to decide wich sub-function have to use.

I want to use case, so i dont have to use pl/pgsql.

This is a non-working example:


CREATE OR REPLACE FUNCTION get_oferta(varchar, varchar, varchar, bool,
OUT cod varchar , OUT description varchar)
returns setof record
security definer
as
$$
select  * from case $4 when true then
    (select * from get_oferta_from_a($1, $2, $3))
else
    (select * from get_oferta_from_b($1, $2, $3))
end;
$$ language sql;

Can i use case for a case like this?

Thanks!
Gerardo