Unlike other databases, PostgreSQL returns a TEXT type by default every time you run a select with a free string. Example:
SELECT 'Text' as FIELD FROM TABLE
in this case above the field
FIELD will be returned with type
Does anyone know if it is possible to change some parameter in PostgreSQL so that it returns a
VARCHAR type in the above case?
Firebird and Oracle return a
I know this would be solved with a CAST however for this I would have to replicate the same for all SQL's of the system besides having to make using
CAST a standard routine of developing new SQL's.
Anyway, does anyone have any idea of anything that might have changed? I'm studying the files