Re: WIP: default values for function parameters - Mailing list pgsql-hackers

From Sam Mason
Subject Re: WIP: default values for function parameters
Date
Msg-id 20081212141448.GQ2459@frubble.xen.chris-lamb.co.uk
Whole thread Raw
In response to Re: WIP: default values for function parameters  ("Rod Taylor" <rod.taylor@gmail.com>)
List pgsql-hackers
On Fri, Dec 12, 2008 at 09:00:52AM -0500, Rod Taylor wrote:
> How about IS or INTO?
> 
> param_name IS 3
> param_name IS 'some string value'

that wouldn't work with NULL would it?  for example is:
 a IS NULL

checking if identifier 'a' IS NULL, or if you're giving NULL to
parameter 'a'.

> 3 INTO param_name
> 'some string value' INTO param_name

looks good.  Just to throw another item in, you could keep with SQL's
general verboseness and use:
 WITH ident = expr

that may be too much though.  Names that were mentioned in the keyword
file are:
 AS IS WITH ON HAVING INTO
and the following un-reserved entries MATCH NAME NAMES

 Sam


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: WIP: default values for function parameters
Next
From: "Pavel Stehule"
Date:
Subject: Re: WIP: default values for function parameters