BUG #10785: error if using x>n AND x
| От | lunda@bitmessage.ch |
|---|---|
| Тема | BUG #10785: error if using x>n AND x |
| Дата | |
| Msg-id | 20140627135405.15694.38636@wrigleys.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #10785: error if using x>n AND x |
| Список | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 10785
Logged by: j.l.
Email address: lunda@bitmessage.ch
PostgreSQL version: 9.3.4
Operating system: Linux 64bit (ubuntu 12.04)
Description:
DOES WORK:
create index planet_osm_point_city_50k_index on planet_osm_point using
gist(way) where
(((capital IS NULL) OR (capital <> 'yes'::text)) AND
(place = ANY ('{city,town}'::text[])) AND
(population IS NOT NULL) AND (population <> ''::text) AND
(regexp_replace(population, '[., ]', '')::int > 50000));
DOES WORK:
create index planet_osm_point_city_50k_index on planet_osm_point using
gist(way) where
(((capital IS NULL) OR (capital <> 'yes'::text)) AND
(place = ANY ('{city,town}'::text[])) AND
(population IS NOT NULL) AND (population <> ''::text) AND
(regexp_replace(population, '[., ]', '')::int between 50000 and 99999));
DOES NOT WORK (ERROR: invalid input syntax for integer: "tower"):
create index planet_osm_point_city_50k_index on planet_osm_point using
gist(way) where
(((capital IS NULL) OR (capital <> 'yes'::text)) AND
(place = ANY ('{city,town}'::text[])) AND
(population IS NOT NULL) AND (population <> ''::text) AND
(regexp_replace(population, '[., ]', '')::int >= 50000) AND
(regexp_replace(population, '[., ]', '')::int < 100000));
В списке pgsql-bugs по дате отправления: