Re: User defined type without single quotes

On Thu, 2013-04-04 at 19:50 -0300, Rodrigo Barboza wrote:
> -- 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?
>
A constant like 10 is initially assigned one of the integer types (the
exact rules are in the documentation).  In order to be able to store
that into a column of a custom type, you need to define a cast between
the integer type and your type with at least assignment context.