From: Joe Conway <mail@joeconway.com>
To: jack <datactrl@tpg.com.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: About Create Type
Date: Sun, 09 Mar 2003 17:33:43 -0800
Message-ID: <3E6BEB77.8060203@joeconway.com> (raw)
In-Reply-To: <003901c2e6a3$6408ef00$1400a8c0@jac>
References: <003901c2e6a3$6408ef00$1400a8c0@jac>
jack wrote:
> When I look at CREATE TYPE on PostgreSql V7.3 Document. What it describes
> is beyond what I can understand. My requirement is just I want to define a
> type "tyAmt" as "NUMERIC (10,2)" for an application in order to make such
> type of columns consistent. Is there any simple way to implement it? Thank
> you!
>
I think you really want to create a DOMAIN. See:
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/sql-createdomain.html
HTH,
Joe
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: pgsql-sql@postgresql.org
Cc: mail@joeconway.com, datactrl@tpg.com.au
Subject: Re: About Create Type
In-Reply-To: <3E6BEB77.8060203@joeconway.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox