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 <[EMAIL PROTECTED]> wrote:
"Willy-Bas Loos" <[EMAIL PROTECTED]> 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
