Re: Why is there a tsquery data type?

Ron Mayer <rm_pg@cheapcomplexdevices.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