Postgres array cast

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

Browse pgsql-general by date

  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