Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> writes: > Does anyone object to making BETWEEN and IN more strict about the data > types? At the moment, you can do this:
> postgres=# SELECT '1234' BETWEEN '10001'::text AND 10002::int4; > ?column? > ---------- > t > (1 row) > I'm thinking that it should throw an error. Same with IN, if the values > in the IN-list can't be coerced to a common type. You *will* get push-back on that ... maybe from people with badly coded applications, but I guarantee there will be complaints. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers