Re: escaped rolenames in pg_has_role

er.. i guess i was misinformed. (by Korry & Susan Douglas´ second edition,
maybe this is relatively new?)
However, could you please answer my question?

On 6/26/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "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
>