| From: | Mathieu Dubois <mathieu(dot)dubois(at)limsi(dot)fr> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | cast bytea to double precision[] |
| Date: | 2011-07-24 19:03:01 |
| Message-ID: | 4E2C6C65.9030608@limsi.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hello,
I have a column of type bytea which contains a vector encoded in a
string (elements are separated by spaces).
The problem is that it uses a lot of storage space.
I would like to convert this column to an ARRAY column with ALTER COLUMN
TYPE.
If I understand correctly, I have to specify a function to cast bytea to
double precision[]. Is it correct?
If this is correct, how to do that?
I use regexp_split_to_array to transform the bytea to a text[] but I
can't figure out how to convert it to double precision[].
I'm using postgres 8.4.
Any idea?
Thanks in advance,
Mathieu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mathieu Dubois | 2011-07-24 19:03:36 | Re: cast bytea to double precision[] |
| Previous Message | Mathieu Dubois | 2011-07-24 18:18:53 | cast bytea to double precision[] |