Lazarus
Programming => Databases => Topic started by: xinyiman on February 11, 2020, 09:27:46 am
-
Goodmorning everyone. I encountered an annoying problem in using the standard components for accessing the postgres database. Basically if I use a similar query
select field1, field2, '' as field3, '' as field4 from mytable
It just returns the fields field1 and filed2. The 3 and 4 do not return them. Because?! How do I solve it?
-
Maybe it can help to isolate the problem. If I write the query it works like this:
select field1, field2, ''::text as field3, ''::text as field4 from mytable
As if the dataset did not recognize the field type.