Message-ID: <1365858403.20086.7.camel@vanquo.pezone.net>
Subject: Re: User defined type without single quotes
From: Peter Eisentraut <peter_e@gmx.net>
To: Rodrigo Barboza <rodrigombufrj@gmail.com>
Cc: pgsql-docs@postgresql.org
Date: Sat, 13 Apr 2013 09:06:43 -0400
In-Reply-To: 
 <CANs8QJbj9Ez6yjRy+pq2-bfBMq5wExzi1-WyCWwBfuB3AusaqQ@mail.gmail.com>
References: 
 <CANs8QJbj9Ez6yjRy+pq2-bfBMq5wExzi1-WyCWwBfuB3AusaqQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

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.


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs