Re: cast record type to array?

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: cast record type to array?
Date: 2010-05-28 10:31:03
Message-ID: hto617$qf1$3@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2010-05-26, Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar> wrote:
> Hi all. Im not being able to cast a record variable into an array.
>
> Im writing a trigger, and i would like to store NEW (and OLD) as text[].
> There is a way to do it in plpgsql? (w/o any contrib modules)

why not store them as text instead?

new::text

is a valid cast.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message alvherre 2010-05-28 15:14:44 Re: Extending Regular Expression bounds limit of 255.
Previous Message Reinier Suurenbroek 2010-05-28 08:07:45 ODBC-link returns zero rows, allthough query should return 3 rows