On 12/01/2012 9:20 PM, Daniel McGreal wrote:
> I have ended up writing a function (more accurately, two functions)
> which always convert a value into an array, either by returning the
> array immediately or by nesting it inside one so that all queries can
> use the second form, above.
>
> CREATE OR REPLACE FUNCTION make_array(anyarray) RETURNS anyarray AS
> 'select $1' LANGUAGE sql IMMUTABLE COST 1;
> CREATE OR REPLACE FUNCTION make_array(anynonarray) RETURNS anyarray AS
> 'select array[$1]' LANGUAGE sql IMMUTABLE COST 1;
Oooh, that's clever. Nice!
People say function overloading is no good ....
--
Craig Ringer