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.
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. |