Re: CREATE TYPE with array

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(at)fgan(dot)de>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-novice(at)postgresql(dot)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