Re: Need help with CASE statement in Function

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Hengky Lie <hengkyliwandouw(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Need help with CASE statement in Function
Date: 2007-10-03 17:07:25
Message-ID: 282657.3138.qm@web31808.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

--- Hengky Lie <hengkyliwandouw(at)gmail(dot)com> wrote:
> My Question is : How to make argument 4 optional ? When IS NULL the function
> will show all transaction between date $1 and $2 and product ID=$3

Could you simply overload your function by having two functions? One with arguement 4 and one
without?

Regards,
Richard Broersma Jr.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tena Sakai 2007-10-04 00:13:48 field separator problem
Previous Message Dawid Kuroczko 2007-10-03 17:04:22 Re: Need help with CASE statement in Function