Re: [DOCS] User defined type without single quotes

2013-04-13 Thread Peter Eisentraut
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);

Re: [DOCS] User defined type without single quotes

2013-04-13 Thread Rodrigo Barboza
Thank you, Peter! On Sat, Apr 13, 2013 at 10:06 AM, Peter Eisentraut wrote: > 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 test