Re: arrays

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ivan <iv(at)psycho(dot)pl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: arrays
Date: 2003-07-28 00:39:06
Message-ID: 25550.1059352746@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

ivan <iv(at)psycho(dot)pl> writes:
> declaration is setof record array_to_setof ( anyarray);

> i trayed created it like "any" array_to_setof( anyarray) but i had problem
> with select. i also trying write setof_to_array as aggregate, but i have
> problem with returns type , because aggregate cat have 'anyarray' as
> result ;(

I think you want to declare it like this:

create function array_to_setof(anyarray) returns setof anyelement as ...

Joe Conway may already have written something like this --- look in his
contrib modules.

regards, tom lane

In response to

  • arrays at 2003-07-27 20:44:25 from ivan

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-07-28 00:41:03 Re: Make clean fails
Previous Message Jenny - 2003-07-27 21:56:40 granularity of locks in postgresql