Hbpgsql problem insert empty date

[marcoprodata]

simple.txt

When insert empty date using fieldput return error:
ERROR: 22007: invalid input syntax for type date: " "

[alcz]

In case of hbpgsql contrib i think you should rather use SQL equivalent of "empty date" state, which is NIL/NULL.
If you want to indicate something else, i think PostgreSQL also has "infinity".
Try SELECT 'infinity'::timestamp, '-infinity'::timestamp.

hbpgsql patch proposals on how to handle such xBase constructs are possible too... should it be converted to NULL?

[marcoprodata]

The problem is when use :fieldPut, i think the problem is in the ValueToString when type field type is date.

[alcz]

Consequently, PostgreSQL doesn't have anything that maps directly to xBase empty date, either:

• don't insert empty date to SQL
• request that you'd like to have hbpgsql ValueToString convert empty date to SQL NULL

Anyway i'll probably commit the latter while doing the sync of hbpgsql contrib NULL support changes from my repo and also Viktor's fork. This will take a while.

[marcoprodata]

I Submit a PR to solve the trouble, please review