X-Original-To: pgsql-sql@postgresql.org
Received: from mail3.tpgi.com.au (mail.tpgi.com.au [203.12.160.59])
	by postgresql.org (Postfix) with ESMTP id 208E1474E42
	for <pgsql-sql@postgresql.org>; Sun,  9 Mar 2003 20:21:33 -0500 (EST)
Received: from jac (bri-ts3-2600-036.tpgi.com.au [203.219.26.36])
	by mail3.tpgi.com.au (8.11.6/8.11.6) with SMTP id h2A1LZT13368
	for <pgsql-sql@postgresql.org>; Mon, 10 Mar 2003 12:21:35 +1100
Message-ID: <003901c2e6a3$6408ef00$1400a8c0@jac>
From: "jack" <datactrl@tpg.com.au>
To: <pgsql-sql@postgresql.org>
Subject: About Create Type
Date: Mon, 10 Mar 2003 11:21:33 +1000
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Archive-Number: 200303/232
X-Sequence-Number: 12272

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!

Jack