Hello Evgenij,
Thanks for the swift response. That is just the information I was looking
for. Thank you very much.
Kind regards,
Silvio
On Thursday, 26 January 2023 at 15:25:14 UTC+1 Evgenij Ryazanov wrote:
> Hello!
>
> NaN is not a literal, it's just an identifier.
>
> In this case you can
Hello!
NaN is not a literal, it's just an identifier.
In this case you can pass it as a character string literal:
INSERT INTO "TABLE"(ID, DOUBLE_COLUMN) VALUES (10, 'NaN');
In more complex cases where data type cannot be determined automatically a
cast is needed:
CAST('NaN' AS DOUBLE