Skip site navigation (1) Skip section navigation (2)

Re: unnest

From: Joe Conway <mail(at)joeconway(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: John Hansen <john(at)geeknet(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: unnest
Date: 2004-11-29 17:23:56
Message-ID: 41AB5B2C.1080204@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Bruce Momjian wrote:
> I assume this is not something for our PostgreSQL CVS, even the later
> SRF implementation.

I agree with that assessment, at least in its present state. For example:

regression=# select * from unnest(array[[1,2,3],[4,5,6]]);
  unnest
--------
       1
       2
       3
       4
       5
       6
(6 rows)

Per SQL99 I think that ought to return something like:

-- output faked
regression=# select * from unnest(array[[1,2,3],[4,5,6]]);
  unnest
--------
  {1,2,3}
  {4,5,6}
(2 rows)

Problem is that a polymorphic SRF cannot (currently at least) both 
accept and return type anyarray.

Joe


In response to

  • Re: unnest at 2004-11-29 02:18:32 from Bruce Momjian

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-11-29 17:44:42
Subject: Re: Stopgap solution for table-size-estimate updatingproblem
Previous:From: Greg StarkDate: 2004-11-29 17:21:06
Subject: Re: Stopgap solution for table-size-estimate updatingproblem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group