Tom Lane wrote: > Albe Laurenz <laurenz.a...@wien.gv.at> writes: >> Is there anything that "varchar_pattern_ops" is needed for that >> "text_pattern_ops" cannot provide? > > Lack of surprise? If you're creating a pattern index on a varchar column, > you'd likely expect to need to mention varchar_pattern_ops. > > The idea that varchar is an alias for text might be second nature to old > Postgres hands, but it's not to most of the world.
Thanks for the explanation! Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
