From: | jco(at)cornelius-olsen(dot)dk |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Postgres array cast |
Date: | 2002-12-27 00:40:54 |
Message-ID: | OF00313A3D.C9629102-ONC1256C9C.00032AE6@dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I'm using Zeos Database Objects to access the database. As it turns out,
it is not able to read array fields from the database.
I was wondering whether there is any way to convert an array to another
type (e.g. text).
I've tried using
select my_array_field::text
and
select text(my_array_field)
But it can't do that. Does anyone know of another compatible type or
whether it is possible to write a type casting operator?
select version();
version
-------------------------------------------------------------
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
Regards
/Jørn Cornelius Olsen
From | Date | Subject | |
---|---|---|---|
Next Message | jco | 2002-12-27 01:23:43 | Re: Postgres array cast |
Previous Message | Tom Lane | 2002-12-26 21:45:00 | Re: RI Constraint display |