Re: multiset patch review - Mailing list pgsql-hackers

From Robert Haas
Subject Re: multiset patch review
Date
Msg-id AANLkTinoMDfgyJTouKu-pp+qvoZvf=mBcQEVu6nndG6v@mail.gmail.com
Whole thread Raw
In response to Re: multiset patch review  (Itagaki Takahiro <itagaki.takahiro@gmail.com>)
Responses Re: multiset patch review
List pgsql-hackers
On Fri, Feb 4, 2011 at 1:15 PM, Itagaki Takahiro
<itagaki.takahiro@gmail.com> wrote:
> On Sat, Feb 5, 2011 at 03:04, Robert Haas <robertmhaas@gmail.com> wrote:
>>>> I am still not in favor of adding this syntax.
>>>
>>> I also don't like the syntax, but unfortunately, almost all of
>>> them are in the SQL standard :-(.
>>
>> The standard specifies this syntax for arrays, or for multisets?
>
> Multisets. But I chose the same function name and syntax because
> arrays *are* multisets by definition.

In math class, maybe.  But in programming, no.  Multiset is a
datatype.  Array is a different datatype.  There is no reason why we
need to clutter our parser with extra keywords to support a
non-standard feature extension.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: more buildfarm breakage
Next
From: PostgreSQL - Hans-Jürgen Schönig
Date:
Subject: SELECT ... WHERE fti_query ORDER BY numeric_col LIMIT x - problem