Re: ODBC Driver 9->11, troubles with dates/NULL... - Mailing list pgsql-odbc

From Clemens Ladisch
Subject Re: ODBC Driver 9->11, troubles with dates/NULL...
Date
Msg-id d76c867b-1c76-9ec0-cb7b-57b7702fac96@ladisch.de
Whole thread Raw
In response to ODBC Driver 9->11, troubles with dates/NULL...  (Marco Gaiarin <gaio@sv.lnf.it>)
Responses Re: ODBC Driver 9->11, troubles with dates/NULL...
List pgsql-odbc
Marco Gaiarin wrote:
> ERRORE:  sintassi di input non valida per il tipo date: ""
> ISTRUZIONE:  INSERT INTO PROTOCOLLI ( ... DATA_REGIST ...) VALUES ( ... E'' ... )
>
> while the table expect a non-NULL:
>
>                Tabella "public.protocolli"
>      Colonna      |          Tipo          | Modificatori
> ------------------+------------------------+--------------
> ...
>  data_regist      | date                   | non null

Why are you mentioning NULL?  This is an empty string, which is not a valid date.

Are you sure that the ODBC driver version makes a difference?
Where should a valid date value come from, if not from the application?


Regards,
Clemens



pgsql-odbc by date:

Previous
From: Marco Gaiarin
Date:
Subject: ODBC Driver 9->11, troubles with dates/NULL...
Next
From: Marco Gaiarin
Date:
Subject: Re: ODBC Driver 9->11, troubles with dates/NULL...