Re: WIP: default values for function parameters

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: WIP: default values for function parameters
Date: 2008-12-12 14:14:48
Message-ID: 20081212141448.GQ2459@frubble.xen.chris-lamb.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2008-12-12 14:22:29 Re: WIP: default values for function parameters
Previous Message David E. Wheeler 2008-12-12 14:14:45 Re: WIP: default values for function parameters