Re: convert custom datatype to array - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: convert custom datatype to array
Date
Msg-id 20071119155056.GE18602@alvh.no-ip.org
Whole thread Raw
In response to Re: convert custom datatype to array  (Mike Charnoky <noky@nextbus.com>)
Responses Re: convert custom datatype to array  (Mike Charnoky <noky@nextbus.com>)
List pgsql-general
Mike Charnoky wrote:
> OK, forgive my ignorance here, but the maintainer of our custom data
> type code is no longer with us and this is new territory for me.  We do
> have a function which takes our custom data type and returns a cstring.
>  Is there a pg function which converts a cstring to text type?  This
> seems to be the missing link to eventually get the data to float4[].

Sure, textin() does that.

--
Alvaro Herrera                 http://www.amazon.com/gp/registry/DXLWNGRJD34J
"Coge la flor que hoy nace alegre, ufana. ¿Quién sabe si nacera otra mañana?"

pgsql-general by date:

Previous
From: Tom Hart
Date:
Subject: Re: convert access sql to postgresql
Next
From: Dragan Matic
Date:
Subject: Timestamp comparison with string in some special cases