Postgresql doubt field number

Question

Postgresql doubt field number

Navigation

#1 by (1 votes)

0

Good I need to enter high values for example 65.000.00 for the price of a product I have a Price field defined as Numeric (18.2) But it only allows me to enter values less than or equal to 999.00 as I would in this case?

sql postgresql

asked by Jorge Ortiz 03.07.2017 в 01:04

source

1 answer

Problems installing selenium on Mac Encode in base 64 file C #

score 1 · Answer 1

The problem is elsewhere. Yes you can.

--PostgreSQL 9.6
--'\' is a delimiter

select version() as postgresql_version;

create table grandes(
    el_valor numeric(18,2)
);

insert into grandes values (1234567899012345.79);

select * from grandes;

Maybe you're confusing points with commas. You could give an example that does not work for you in a place like this: link