Re: ERROR: Bad timestamp external representation '' - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: Bad timestamp external representation ''
Date
Msg-id 24766.984943811@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: Bad timestamp external representation ''  (Boris <koester@x-itec.de>)
Responses Re[2]: ERROR: Bad timestamp external representation ''  (Boris <koester@x-itec.de>)
List pgsql-general
Boris <koester@x-itec.de> writes:
> insert into table test (...) values ('NULL') does not work,
> but in mysql it works.

MySQL does not define the SQL standard.

Write
    insert into table test (...) values (NULL);
if you want something that is portable and standards-compliant.

            regards, tom lane

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: ERROR: Bad timestamp external representation ''
Next
From:
Date:
Subject: