Skip to content

write value Nan error #172

Open
Open
@nuage32

Description

@nuage32

insert NaN error:

2023-03-29 18:27:55.398 CST [654503] new@new ERROR: column "nan" does not exist at character 30483

insert into products (price) values(NaN)

in database:
Table "public.products"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+--------------------------------------
id | integer | | not null | nextval('products_id_seq'::regclass)
price | numeric | | |

insert into products (price) values(NaN);

ERROR: column "nan" does not exist
LINE 1: insert into products (price) values(NaN);
^

insert into products (price) values('NaN');

INSERT 0 1

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions