Skip site navigation (1) Skip section navigation (2)

Re: CREATE TYPE with array

From: "Sanjeev Sharma (Kinera)" <sanjeev(at)kinera(dot)com>
To: "Wolfgang Drotschmann" <drotschm(at)fgan(dot)de>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: CREATE TYPE with array
Date: 2003-07-24 11:37:25
Message-ID: 03dd01c351d7$f49b68f0$0601a8c0@sanjeev (view raw or flat)
Thread:
Lists: 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(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


In response to

pgsql-novice by date

Next:From: William YuDate: 2003-07-24 11:40:07
Subject: Re: Locking tables
Previous:From: papapepDate: 2003-07-24 11:30:13
Subject: Questions about Exists-Not exists clause

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group