Hello.
Currently, we are trying to get a new SQL query to function within DB Connect. The SQL query runs against a Postgres database. Although the SQL query runs fine in batch mode, it is not running so well when setting up the same in rising mode. Attached is a screenshot of the error message we are receiving.
We tried setting the rising column as "created_at". Also, we tried adding the following lines to the SQL query:
But we receive error messages:
Can someone suggest the best approach to resolving this?
Regards,
Max