Re: WIP: default values for function parameters

From: Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Peter Eisentraut" <peter_e(at)gmx(dot)net>
Subject: Re: WIP: default values for function parameters
Date: 2008-12-09 13:16:19
Message-ID: 0D6A6431-5D24-48F6-8DC4-E3E507AFB3EA@pointblue.com.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Ok, how about

CREATE FUNCTION FOO (one int, two float8 default 3.14, three int[]
default '{6,7,8,90}')....;

and than SELECT FOO( 777, DEFAULT, '{1,2,3,4,5}');

I have no idea what SQL standard says in that case, all I know is that
keyword DEFAULT exists in it, and is used in queries for similar
purpose.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message ohp 2008-12-09 13:23:16 Re: cvs head initdb hangs on unixware
Previous Message Peter Eisentraut 2008-12-09 13:14:39 Re: WIP: default values for function parameters