Re: SQL99 ARRAY support proposal - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: SQL99 ARRAY support proposal
Date
Msg-id Pine.LNX.4.44.0303122311400.1643-100000@peter.localdomain
Whole thread Raw
In response to Re: SQL99 ARRAY support proposal  (Joe Conway <mail@joeconway.com>)
Responses Re: SQL99 ARRAY support proposal  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
Joe Conway writes:

> 2) Implement the following new builtin functions
>       array_push(anyarray, anyelement) returns anyarray
>       array_pop(anyarray) returns anyelement
>       array_subscript(anyarray, int) yields anyelement
>       singleton_array(anyelement) returns anyarray
>          - any reason not to call this one simply "array"?
>       split(text, text) returns text[]
>          - split string into array on delimiter
>       implode(text[], text) returns text
>          - join array elements into a string using given string delimiter

I think this goes too far.  It is just an invitation to people to create
bad database designs by using arrays as lists.  Create an array support
package on gborg if you like, but I feel this should not be in the
mainline.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: [INTERFACES] Roadmap for FE/BE protocol redesign
Next
From: Joe Conway
Date:
Subject: Re: regproc's lack of certainty is dangerous