Postgres query bug?!

[xinyiman]

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]

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.