Skip site navigation (1) Skip section navigation (2)

Default Values and Pl/Pgsql Function Calls

From: Andrew Spencer <andrew(at)fallingblue(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Default Values and Pl/Pgsql Function Calls
Date: 2001-09-27 14:45:49
Message-ID: Pine.LNX.4.10.10109270841270.31051-100000@japan.fallingblue.com (view raw or flat)
Thread:
Lists: pgsql-novice
What is the proper way to call a pl/pgsql function when for a majority of
parameters the default value declared previously is wanted?  Is there
anything similar to named parameters?  I would have thought the call would
be similar to: my_function(NULL, NULL, my-value, NULL) using 'NULL' for
the values desired to be defaults.  Thanks!


pgsql-novice by date

Next:From: richard leotardDate: 2001-09-28 10:18:49
Subject: functionss
Previous:From: Tom LaneDate: 2001-09-26 18:08:28
Subject: Re: Index not used for simple query, and yes I ran vacuum analyze

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group