Re: generic return for functions

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Avi Schwartz <avi(at)CFFtechnologies(dot)com>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: generic return for functions
Date: 2003-06-01 12:21:12
Message-ID: 1054470071.11968.115.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> thing that causes me some minor grief is the fact that currently you
> cannot have default values to function parameters, a feature we use a
> lot.

The default value is used when the parameter is NULL or unprovided?

fn(integer, integer, integer default 32)

select fn(integer, integer); <- Third argument would be '32'?

When PostgreSQL gets named parameters the above probably makes sense to
add.

A TODO item?
--
Rod Taylor <rbt(at)rbt(dot)ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Avi Schwartz 2003-06-01 15:21:36 Re: generic return for functions
Previous Message Rod Taylor 2003-06-01 12:03:23 Re: Upgrade 7.2.3 -> 7.3 or more