Re: Initial review of xslt with no limits patch

David E. Wheeler <david@kineticode.com>

From: "David E. Wheeler" <david@kineticode.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Pavel Stehule <pavel.stehule@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Andrew Dunstan <andrew@dunslane.net>, Mike Fowler <mike@mlfowler.com>, pgsql-hackers@postgresql.org
Date: 2010-08-07T05:16:06Z
Lists: pgsql-hackers
On Aug 6, 2010, at 9:59 PM, Tom Lane wrote:

> It's not immediately clear to me what an ordered-pair type would get you
> that you don't get with 2-element arrays.

Just syntactic sugar, really. And control over how many items you have (a bounded pair rather than an unlimited element array).

> A couple of quick experiments suggest that 2-D arrays might be the thing
> to use.  They're easy to construct:
> 
> regression=# select array[[1,2],[3,4]];
>     array     
> ---------------
> {{1,2},{3,4}}
> (1 row)
> 
> and you can build them dynamically at need:
> 
> regression=# select array[[1,2],[3,4]] || array[5,6];
>      ?column?       
> ---------------------
> {{1,2},{3,4},{5,6}}
> (1 row)
> 
> This is not exactly without precedent, either: our built-in xpath()
> function appears to use precisely this approach for its namespace-list
> argument.

Agreed.

Best,

David