plpgsql default arguments

From: Greg Lindstrom <greg(dot)lindstrom(at)novasyshealth(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: plpgsql default arguments
Date: 2005-04-14 15:26:38
Message-ID: 425E8BAE.3080301@novasyshealth.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello-

I am running postgres on a Linux system and have been using plpgsql to
write functions. Is there a way to specify default arguments? For
example, I would like to offer the user to specify a date to use in my
function but if no date is specified I would like to use the current
date. Easy to do in C, C++, Perl, and Python (and, I assume Java), but
I can't find anything in the documentation or on Google. Is it possible
in plpgsql?

Thanks,
--greg

--
Greg Lindstrom 501 975.4859 (office)
Senior Programmer 501 219-4455 (fax)
NovaSys Health greg(dot)lindstrom(at)novasyshealth(dot)com
Little Rock, Arkansas

"We are the music makers, and we are the dreamers of dreams." W.W.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2005-04-14 15:45:58 Re: plpgsql default arguments
Previous Message Devrim GUNDUZ 2005-04-14 15:04:44 (S)RPMs for PostgreSQL 8.0.2 are ready.