Re: [SQL] decimal

From: Jeff MacDonald <jeff(at)hub(dot)org>
To: Ale Vojek <alesv(at)fbl(dot)cz>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] decimal
Date: 1999-09-22 13:23:43
Message-ID: Pine.LNX.4.10.9909221022150.27527-100000@penguin.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 Vojek 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 MacDonald
jeff(at)hub(dot)org webpage: http://hub.org/~jeff
jeff(at)pgsql(dot)com irc: bignose on EFnet
======================================================

In response to

  • decimal at 1999-09-22 12:09:44 from Aleš Vojáček

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 1999-09-22 15:06:26 Re: [SQL] decimal
Previous Message Paulo Roberto Kappke 1999-09-22 13:12:40 Date type select