public inbox for [email protected]  

help / color / mirror / Atom feed

From: Peter Eisentraut <[email protected]>
To: Rodrigo Barboza <[email protected]>
Cc: [email protected]
Subject: Re: User defined type without single quotes
Date: Sat, 13 Apr 2013 09:06:43 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CANs8QJbj9Ez6yjRy+pq2-bfBMq5wExzi1-WyCWwBfuB3AusaqQ@mail.gmail.com>
References: <CANs8QJbj9Ez6yjRy+pq2-bfBMq5wExzi1-WyCWwBfuB3AusaqQ@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>

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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: User defined type without single quotes
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox