Re: CREATE TYPE with array
От | Sanjeev Sharma (Kinera) |
---|---|
Тема | Re: CREATE TYPE with array |
Дата | |
Msg-id | 03dd01c351d7$f49b68f0$0601a8c0@sanjeev обсуждение исходный текст |
Ответ на | CREATE TYPE with array (Wolfgang Drotschmann <drotschm@fgan.de>) |
Список | 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
В списке pgsql-novice по дате отправления: