You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
There are certain kinds of data that we are storing using floating-point datatypes. We should generally avoid that, as they are imprecise and we could lose data. We should analyze it case by case.
One example:
create table project (
id serial not null,
activation boolean default true not null,
init date,
_end date,
invoice double precision,
est_hours double precision,
areaId integer not null,
description varchar(256),
type varchar(256),
moved_hours double precision,
sched_type varchar(256),
constraint pk_Project primary key (id)
) ;
We could store the "invoice" as an integer of cents, and hours as integers of minutes like we do for tasks.
The text was updated successfully, but these errors were encountered:
There are certain kinds of data that we are storing using floating-point datatypes. We should generally avoid that, as they are imprecise and we could lose data. We should analyze it case by case.
One example:
We could store the "invoice" as an integer of cents, and hours as integers of minutes like we do for tasks.
The text was updated successfully, but these errors were encountered: