DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=hBCUr9VLb/mDAT/kv5PNadwywh1Cf1eAZlRdQhdAE/4vAT9bPwSII5sFqSNsnvMWzxScNZ+6Kw25oruQg8jEKnSTJuULghpyOEjyrqYp9VQxFnfUZ6FXvFFSxLPqr/EZjHJzVtb133kmunLpaSW1Hliz5+HckMYQNCbCHhCt6aM=
Message-ID: <c2d9e70e0707181940x4cc70527ka211e1789f3f2237@mail.gmail.com>
Date: Wed, 18 Jul 2007 21:40:51 -0500
From: "Jaime Casanova" <systemguards@gmail.com>
To: "Norm Garand" <indianlakesolutions@rogers.com>
Subject: Re: Inserting an IF statement in the middle of a SELECT in pl/pgSQL
	code
Cc: pgsql-sql@postgresql.org
In-Reply-To: <c2d9e70e0707181939p6cfaaa82n50a10ca80ee84f2@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <c2d9e70e0707172150j4c319010n17f245c6807aef68@mail.gmail.com>
	<561336.16779.qm@web88309.mail.re4.yahoo.com>
	<c2d9e70e0707181939p6cfaaa82n50a10ca80ee84f2@mail.gmail.com>

sorry, i resubmit to the list

On 7/18/07, Jaime Casanova <systemguards@gmail.com> wrote:
> On 7/18/07, Norm Garand <indianlakesolutions@rogers.com> wrote:
> > Thanks Jaime:
> >
> > I tried using the CASE function and it still didn't work.
> >
> > What I need to do is set a conditional, so that if the parameter is NULL, then the this line is
> > ignored completely and of course the opposite applies, if the value is "something", then this line
> > is included in the SELECT. I've just reworded and resubmitted my question and of course, again, I
> > didn't include the facts above. Thanks, for the response, anything is appreciated.
> >
>
> ok, i will do your work...
>
> CREATE OR REPLACE FUNCTION t(con_stock boolean)
>  RETURNS SETOF ttdinv001214 AS
> $BODY$
> select * from ttdinv001214
> where substring(trim(t_item), 1, 3) = 'DPP'
>  and case $1 when true then t_stoc > 0 else 1 = 1 end;
> $BODY$
>  LANGUAGE 'sql' VOLATILE;
>
>
> note the "else 1=1" part, i could be used "else true" or something else
>
> --
> regards,
> Jaime Casanova
>
> "Programming today is a race between software engineers striving to
> build bigger and better idiot-proof programs and the universe trying
> to produce bigger and better idiots.
> So far, the universe is winning."
>                                       Richard Cook
>


-- 
Atentamente,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook