Support for date - integer in PostgreSQL mode

Relational Database

Brought to you by: fredt, unsaved

#374 Support for date - integer in PostgreSQL mode

Milestone: Next Release (example)

Status: open-fixed

Owner: Fred Toussi

Labels: None

Priority: 5

Updated: 2025-05-29

Created: 2025-05-24

Creator: Vasiliy Gagin

Private: No

PostgreSQL supports expression like "current_date - 1" and does not support "current_date - 1 DAY".
Please add support for "date +/- integer" expressions, like "current_date -1" in PostgreSQL compatigility mode.

Discussion

Fred Toussi - 2025-05-29

status: open --> open-fixed

assigned_to: Fred Toussi
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Fred Toussi - 2025-05-29

Thanks for reporting. Support for this has been committed to SVN for the next release.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Support for date - integer in PostgreSQL mode

Relational Database

Group

Searches

Help

#374 Support for date - integer in PostgreSQL mode

Discussion