Postgres query bug?!
lazarus / 16-Databases

----------------------------------------------------------------------
xinyiman · 2020-02-11 08:27

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?

----------------------------------------------------------------------
xinyiman · 2020-02-11 10:16

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.