| 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: | Whole Thread | Raw Message | 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. |