Re: cast record type to array? - Mailing list pgsql-sql

From Jasen Betts
Subject Re: cast record type to array?
Date
Msg-id hto617$qf1$3@reversiblemaps.ath.cx
Whole thread Raw
In response to cast record type to array?  (Gerardo Herzig <gherzig@fmed.uba.ar>)
Responses Re: cast record type to array?  (Gerardo Herzig <gherzig@fmed.uba.ar>)
List pgsql-sql
On 2010-05-26, Gerardo Herzig <gherzig@fmed.uba.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.



pgsql-sql by date:

Previous
From: Brent DeSpain
Date:
Subject: Re: Extending Regular Expression bounds limit of 255.
Next
From: alvherre
Date:
Subject: Re: Extending Regular Expression bounds limit of 255.