Re: CREATE TYPE with array - Mailing list pgsql-novice

HI ALL,
             I'am a new comer to postgres and I'am facing a problem.Please
help me out. How do we convert Varchar field to Numeric , I have used
CAST( Var As Numeric) but it is giving error and even to_number is not
working . Any help will be highly appreciated.
Thanks
Sanjeev

----- Original Message -----
From: "Wolfgang Drotschmann" <drotschm@fgan.de>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: <pgsql-novice@postgresql.org>
Sent: Thursday, July 24, 2003 11:27 AM
Subject: Re: [NOVICE] CREATE TYPE with array


> Hi Tom!
>
> Tom Lane schrieb:
> > [...]
> > In short, declare l as int4array not int4array[].
>
> You're right - I must have been blind.
>
> Thanks a lot!
>
> Best regards,
> Wolfgang
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html