Postgres Pro
Downloads
Home   >   mailing lists

Re: Need help with CASE statement in Function - Mailing list pgsql-sql

From Richard Broersma Jr
Subject Re: Need help with CASE statement in Function
Date
Msg-id 282657.3138.qm@web31808.mail.mud.yahoo.com
Whole thread Raw
In response to Need help with CASE statement in Function  ("Hengky Lie" <hengkyliwandouw@gmail.com>)
List pgsql-sql
Tree view 
--- Hengky Lie <hengkyliwandouw@gmail.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.

pgsql-sql by date:

Previous
From: "Dawid Kuroczko"
Date:
Subject: Re: Need help with CASE statement in Function
Next
From: "Tena Sakai"
Date:
Subject: field separator problem