DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:References:In-Reply-To:Mime-Version:Content-Transfer-Encoding:Content-Type:Message-Id:Cc:X-Mailer:From:Subject:Date:To;
	b=d/ZZ+sZqM/FYMjhUwU0usfODPLxBQeKLpOTz4s80+fHixzEqyeLxkc/YESlG1zoDJWsvTUOA8JabE0GYZD84aC3vAB6m+J2hMuFdl0BmCbR3qmSk7is8DfN4O7cMZhLqCTmCB/eDYX82UAdzkeif6ri/0uNHByOVMqMNdhTxo7A=
	;
References: <4FCF7255.8070002@jfcomputer.com>
In-Reply-To: <4FCF7255.8070002@jfcomputer.com>
Mime-Version: 1.0 (1.0)
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii
Message-Id: <51DDFD64-F1F6-478D-AAE2-4456AACD0601@yahoo.com>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
From: David Johnston <polobo@yahoo.com>
Subject: Re: defaults in a function
Date: Wed, 6 Jun 2012 11:27:40 -0400
To: "johnf@jfcomputer.com" <johnf@jfcomputer.com>

On Jun 6, 2012, at 11:08, John Fabiani <johnf@jfcomputer.com> wrote:

> Hi,
> In python when I create a method/function is set a default value for a pas=
sed value if one is not provided.
>=20
> def foo(self, event =3D None):
>=20
> In the above function if the second value is not passed a value of None is=
 used as the default.
>=20
> Is this possible with plpgsql???
>=20
> Johnf
>=20

http://www.postgresql.org/docs/9.0/interactive/sql-createfunction.html

... param_n type DEFAULT value
OR
... param_n type =3D value

It is SQL DDL syntax and not specific to the language the function is writte=
n in.

David J.