User defined type without single quotes - Mailing list pgsql-docs

From Rodrigo Barboza
Subject User defined type without single quotes
Date
Msg-id CANs8QJbj9Ez6yjRy+pq2-bfBMq5wExzi1-WyCWwBfuB3AusaqQ@mail.gmail.com
Whole thread Raw
Responses Re: User defined type without single quotes
List pgsql-docs
Hello.
I defined a new type to represent an unsigned int, but when I try do run a query it complains because it is not quoted and casted to my type.

Suppose I have a table:

-- my_uint32 is my new type
CREATE TABLE test (a my_uin32);

If I try to run this insert, postgres complain about the type:
INSERT INTO teste (a) VALUES (10);

But this one works:
NSERT INTO teste (a) VALUES ('10'::my_uint);

Is there a way to avoid the single quotes?

pgsql-docs by date:

Previous
From: Josh Kupershmidt
Date:
Subject: Re: broken index references
Next
From: 正品折扣护肤
Date:
Subject: 69元!抢购雅诗兰黛2011全能细胞亮白防晒调色BB霜SPF35/PA+++30ml隐没肌肤一切瑕疵,使肌肤均匀有致,更有不同凡响的防晒效果!让您出行更方便!(AD)