Обсуждение: decimal

Поиск
Список
Период
Сортировка

decimal

От
"Aleš Vojáček"
Дата:
Hi all,
I'm new in postress world,
I have one question exists any datatype like decimal (12,6) (123456789012.123456) in postgress?
sorry for my english
Ales

Re: [SQL] decimal

От
Jeff MacDonald
Дата:
greetings,

you need the numeric type

ie

create table example(thisvaluse    numeric(12,6)
);

insert into table example values(012345678912.012345);


On Wed, 22 Sep 1999, Ale� Voj��ek wrote:

> Hi all,
> I'm new in postress world, 
> I have one question exists any datatype like decimal (12,6) (123456789012.123456) in postgress?
> sorry for my english
> Ales
> 

======================================================
Jeff MacDonaldjeff@hub.org    webpage: http://hub.org/~jeffjeff@pgsql.com    irc: bignose on EFnet
======================================================



Re: [SQL] decimal

От
Tom Lane
Дата:
"Aleš Vojáček" <alesv@fbl.cz> writes:
> <META content=3Dtext/html;charset=3Diso-8859-2 =
> http-equiv=3DContent-Type>
> <META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT color=3D#000000 size=3D2>Hi all,</FONT></DIV>
> <DIV><FONT color=3D#000000 size=3D2>I'm new in postress world, =
> </FONT></DIV>
> <DIV><FONT color=3D#000000 size=3D2>I have one question exists any =
> datatype like=20
> decimal (12,6) (123456789012.123456) in postgress?</FONT></DIV>
> <DIV><FONT color=3D#000000 size=3D2>sorry for my english</FONT></DIV>
> <DIV><FONT color=3D#000000 size=3D2>Ales</FONT></DIV></BODY></HTML>

Please don't use HTML in email...

Yes, there's a full decimal/numeric implementation in Postgres 6.5
and later.
        regards, tom lane