Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> writes:
> Could similar logic argue that we'd want special types for regular
> expressions too? That seems quite parallel to the tsquery type to me.
Yeah, it certainly seems like something we might want to consider in
future --- we could get rid of that klugy cache for compiled regexps,
for one thing. An implicit cast from text to the regexp type would
cover backwards compatibility issues, I think.
regards, tom lane