Re: proposal sql: labeled function params

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Hannu Krosing" <hannu(at)2ndquadrant(dot)com>
Cc: Decibel! <decibel(at)decibel(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Robert Haas" <robertmhaas(at)gmail(dot)com>, "Bruce Momjian" <bruce(at)momjian(dot)us>, "Peter Eisentraut" <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: proposal sql: labeled function params
Date: 2008-08-23 06:21:39
Message-ID: 162867790808222321q7ddc7a89s1a213c69a7e8373e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

2008/8/22 Hannu Krosing <hannu(at)2ndquadrant(dot)com>:
> On Thu, 2008-08-21 at 23:41 -0500, Decibel! wrote:
>> On Aug 20, 2008, at 8:26 AM, Pavel Stehule wrote:
>
>> How about we poll -general and see what people say? I'll bet Tom a
>> beer that no one replies saying they've created a => operator (unless
>> maybe PostGIS uses it).
>
> Does Oracle use => for "labeled function params" or just named
> arguments ?
>

Oracle use it for named arguments - what I know, similar it doesn't
allow functionality as labeled params publicly - SQL/XML use it.

>> If we're really worried about it we can have a GUC for a few versions
>> that turns off named parameter assignment. But I don't think we
>> should compromise the design on the theory that some folks might be
>> using that as an operator *and* can't change their application to
>> wrap it's use in ().
>
> I still think that better approach is allowing RECORD as input type and
> do all the things Pavel proposed with a function that iterates over
> record.
>

record or hash table - it's implementation - second step. We have to
find syntax and semantic now.

Pavel

> --------------
> Hannu
>
>
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2008-08-23 06:22:09 Re: [HACKERS] WITH RECURSIVE patches 0818
Previous Message Pavel Stehule 2008-08-23 06:20:44 Re: proposal sql: labeled function params