Re: About Create Type

From: Joe Conway <mail(at)joeconway(dot)com>
To: jack <datactrl(at)tpg(dot)com(dot)au>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: About Create Type
Date: 2003-03-10 01:33:43
Message-ID: 3E6BEB77.8060203@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message James Cooper 2003-03-10 02:09:30 types?
Previous Message jack 2003-03-10 01:21:33 About Create Type