Re: Fwd: Proposal: variant of regclass

On 2014-04-07 12:59:36 -0400, Tom Lane wrote:
> Andres Freund <andres@2ndquadrant.com> writes:
> > There's actually another good reason to not copy regclass's behaviour:
> 
> > postgres=# CREATE TABLE "123"();
> > CREATE TABLE
> > postgres=# SELECT '123'::regclass;
> >  regclass
> >  ----------
> >   123
> >   (1 row)
> 
> > I don't think that's fixable for ::regclass, but we shouldn't copy it.
> 
> I think that's not proving what you thought; the case is correctly handled
> if you quote:

I know, but it's a pretty easy to make mistake. Many if not most of the
usages of regclass I have seen were wrong in that way.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services