Re: cast bytea to double precision[]

From: Mathieu Dubois <mathieu(dot)dubois(at)limsi(dot)fr>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: cast bytea to double precision[]
Date: 2011-07-25 15:58:02
Message-ID: 4E2D928A.1040305@limsi.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 07/25/2011 05:54 PM, Merlin Moncure wrote:
> On Sun, Jul 24, 2011 at 2:03 PM, Mathieu Dubois<mathieu(dot)dubois(at)limsi(dot)fr> wrote:
>> I have found a solution by myself for the conversion:
>> regexp_split_to_array(sig_vector, E',')::double precision[] (elements are in
>> fact separated by commas).
>>
>> To convert my column I have used:
>> ALTER TABLE my_table ALTER sig_vector TO double precision[] USING
>> regexp_split_to_array(sig_vector, E',')::double precision[];
>>
>> Is that correct?
>> Is it correct to pass the column name to regexp_split_to_array()?
> Yeah -- you are just passing a column's data into a function as an
> argument -- standard practice. This will work -- your bytea is really
> a text column, so it's just a matter of breaking up the string.
> regexp_* functions are great for that.
Thank you very much for your reply.

I will launch the conversion right now.

Mathieu

> merlin
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message dev ss 2011-07-25 19:56:55 Re: Datetime stored in bigint
Previous Message Merlin Moncure 2011-07-25 15:54:33 Re: cast bytea to double precision[]