Re: array_map not SQL accessible? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: array_map not SQL accessible?
Date
Msg-id 26397.1233339467@sss.pgh.pa.us
Whole thread Raw
In response to array_map not SQL accessible?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: array_map not SQL accessible?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> I'm wondering why don't we expose the array_map() function to the SQL
> level.

It requires some notion of "reference to function", which doesn't really
exist in SQL.  (Please don't say you're going to pass it a function
OID.)

> As it happens, I need to use it in the pg_dump support for TOAST
> reloptions.

Maybe something involvingARRAY(SELECT foo(x) FROM UNNEST(arrayvariable) x)
        regards, tom lane


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: Should IS DISTINCT FROM work with ANY()?
Next
From: Alvaro Herrera
Date:
Subject: Re: array_map not SQL accessible?