SELECT 
  MAX(geoname_id)                           AS geoname_id,
  MAX(geoname_name_id)                      AS geoname_name_id,
  MAX(places_full_name)                     AS places_full_name,
  country_code                              AS country_code,
  postal_code                               AS postal_code,
  MAX(postal_full_name)                     AS postal_full_name
  --
FROM (
  SELECT *
  FROM (
    SELECT 
      gplaces.geoname_id                    AS geoname_id,
      gnames.geoname_name_id                AS geoname_name_id, 
      trim(gplaces.full_name)               AS places_full_name, 
      null::text                            AS postal_full_name,
      trim(gplaces.country_code)            AS country_code, 
      trim(gnames.alternate_name)           AS postal_code 
      -- 
    FROM     xwor.geoname_places            AS gplaces
    JOIN     xwor.geoname_places_names      AS gnames  ON gnames.geoname_id = gplaces.geoname_id
    WHERE    gnames.iso_language = 'post'
    ORDER BY gplaces.country_code, gnames.alternate_name
  ) AS places
UNION 
  SELECT *
  FROM (
    SELECT 
      null::bigint                          AS geoname_id,
      null::bigint                          AS geoname_name_id,
      null::text                            AS places_full_name, 
      trim(gpostal.place_name)              AS postal_full_name, 
      trim(gpostal.country_code)            AS country_code, 
      trim(gpostal.postal_code)             AS postal_code 
      -- 
    FROM     xwor.geoname_places_postal     AS gpostal
    ORDER BY gpostal.country_code, gpostal.postal_code
  ) AS postal
) AS x
WHERE country_code = 'US' AND geoname_id IS NULL
GROUP BY country_code, postal_code
ORDER BY country_code, postal_code
;