Re: escaped rolenames in pg_has_role

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Willy-Bas Loos" <willybas(at)gmail(dot)com> writes:
>> A quote in the data might be real data or quoting, and you have no way to
>> tell the difference.

> It's not so bad, because a parameter of type name cannot start with a quote.

Sure it can.

regression=# select '"Fooey"'::name;
  name   
---------
 "Fooey"
(1 row)

regression=# create table foo ( """Fooey""" int);
CREATE TABLE
regression=# \d foo
      Table "public.foo"
 Column  |  Type   | Modifiers 
---------+---------+-----------
 "Fooey" | integer | 

regression=# 

			regards, tom lane