Albe Laurenz <[email protected]> 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.
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
