SQL Statement Parsing Error
Greetings;
In version 10.1.0 of UniDac I have a problem in type conversions with PostgreSQL, this problem was not present in the previous version.
Example: "SELECT id, name::text FROM customer"
In the example SQL statement I get an error in the "name::text" part, as it is known, type conversions can be done with the ":::" operator in PostgreSQL, but in version 10.1.0 of UniDac, it recognises "::text" as a parameter called "text".
Of course it is possible to do it as "CAST(name AS text)" but this is a long way and it is difficult to change them in the whole project.
Best regards.