Re: [SQL] cast record type to array?

2010-05-28 Thread Jasen Betts
On 2010-05-26, Gerardo Herzig 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

Re: [SQL] Extending Regular Expression bounds limit of 255.

2010-05-28 Thread alvherre
Excerpts from Brent DeSpain's message of jue may 27 18:55:55 -0400 2010: > It looks like most of our tools are using the Perl version of regular > expressions with an upper limit of a bound being 32766. Is there any way to > change this in PG? Or can I change from POSIX to Perl? See regcomp.c; y

Re: [SQL] Extending Regular Expression bounds limit of 255.

2010-05-28 Thread Brent DeSpain
Yep. That is what I was looking at this morning. It is probably too late in this release of our project to make this change. Thanks for the help. Brent DeSpain Schweitzer Engineering Laboratories, Inc. On Fri, May 28, 2010 at 9:14 AM, alvherre wrote: > Excerpts from Brent DeSpain's message o

Re: [SQL] cast record type to array?

2010-05-28 Thread Gerardo Herzig
Jasen Betts wrote: > On 2010-05-26, Gerardo Herzig 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