Re: array/function question - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: array/function question
Date
Msg-id 20090519125228.GB6471@alvh.no-ip.org
Whole thread Raw
In response to Re: array/function question  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: array/function question  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Pavel Stehule escribió:

> postgres=# create or replace function xx(anyarray, anyarray) returns
> bool[] as $$
> select array(select (select x = any(select y from unnest($2) g2(y)))
> from unnest($1) g(x))
> $$ language sql immutable;
> CREATE FUNCTION

There ain't no unnest() function in 8.3 ...

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: array/function question
Next
From: Tom Lane
Date:
Subject: Re: INTERVAL data type and libpq - what format?