Re: [SQL] decimal - Mailing list pgsql-sql

From Jeff MacDonald
Subject Re: [SQL] decimal
Date
Msg-id Pine.LNX.4.10.9909221022150.27527-100000@penguin.hub.org
Whole thread Raw
In response to decimal  ("Aleš Vojáček" <alesv@fbl.cz>)
List 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� 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
======================================================



pgsql-sql by date:

Previous
From: Stuart Rison
Date:
Subject: [GENERAL] UPDATE feature or bug?
Next
From: Paulo Roberto Kappke
Date:
Subject: Date type select