Thread: About Create Type

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

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

Thanks Joe. Yes, that is exactly what I need.

Jack