dima@koulikoff.ru writes:
> The request ...
> returns Russian names in :name field from the geoname_names table
> But if I add a line
> ORDER BY CASE WHEN geoname_names.name IS NOT NULL THEN geoname_names.name
> ELSE geonames.name END
> at the end of the request all the values for name are taken from the
> geonames table.
I can't reproduce any such misbehavior with the given information
and some made-up data. Can you provide a self-contained test case?
Or at least EXPLAIN (ANALYZE, VERBOSE) output for both queries?
regards, tom lane