On Tue, Mar 17, 2020 at 06:43:51PM +0100, Julien Rouhaud wrote: > On Tue, Mar 17, 2020 at 05:31:47PM +0100, Christoph Berg wrote: >> Not sure if that's the case there, but reg* typecasts are very handy >> when used interactively in ad-hoc queries. > > +1. I'm obviously biased, but I find it quite useful when querying pg_depend, > which may become more frequent once we start generating warnings about > possibly > corrupted indexes.
That means less joins for lookup queries, and collations can be schema-qualified, so I would be in favor of adding it rather than not. Now, it is true as well that ::regcollation is not a mandatory requirement for the feature discussed on this thread. -- Michael
signature.asc
Description: PGP signature