Postgres array cast - Mailing list pgsql-general

From jco@cornelius-olsen.dk
Subject Postgres array cast
Date
Msg-id OF00313A3D.C9629102-ONC1256C9C.00032AE6@dk
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: RI Constraint display
Next
From: jco@cornelius-olsen.dk
Date:
Subject: Re: Postgres array cast