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

From Dimitri Fontaine
Subject Re: WIP: default values for function parameters
Date
Msg-id DFF7D108-E023-4B06-9F22-F452BFC97C5C@hi-media.com
Whole thread Raw
In response to Re: WIP: default values for function parameters  ("Ian Caulfield" <ian.caulfield@gmail.com>)
Responses Re: WIP: default values for function parameters  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: WIP: default values for function parameters  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Le 12 déc. 08 à 14:14, Ian Caulfield a écrit :
> unpopular, and '=>' et al conflict with operators, would verilog-style
> syntax - eg function( .param(value) ) - be an idea?

Ok, time to revisit the classics then ;)  http://www.gigamonkeys.com/book/functions.html#keyword-parameters

That would give us things like this:  SELECT foo(1, :name 'bar', :quantity 10);

As colon character does not appear in the list of allowed characters
for the CREATE OPERATOR, it seems it could be valid.  http://www.postgresql.org/docs/8.3/interactive/sql-
createoperator.html

Regards,
- --
dim


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Darwin)

iEYEARECAAYFAklCaCMACgkQlBXRlnbh1blryQCfR9/6qtOlSAOiMbQ+RD8PRTi+
bsoAn2UiLMwZOG9nanXyMWfh5iAbQVTX
=p37W
-----END PGP SIGNATURE-----


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: psql commands for SQL/MED
Next
From: Zdenek Kotala
Date:
Subject: Re: [Patch] Space reservation (pgupgrade)