pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedAbout Create Type
3+ messages / 2 participants
[nested] [flat]
* About Create Type
@ 2003-03-10 01:21 jack <datactrl@tpg.com.au>
0 siblings, 1 reply; 3+ messages in thread
From: jack @ 2003-03-10 01:21 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: About Create Type
@ 2003-03-10 01:33 Joe Conway <mail@joeconway.com>
parent: jack <datactrl@tpg.com.au>
0 siblings, 1 reply; 3+ messages in thread
From: Joe Conway @ 2003-03-10 01:33 UTC (permalink / raw)
To: jack <datactrl@tpg.com.au>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: About Create Type
@ 2003-03-10 04:48 jack <datactrl@tpg.com.au>
parent: Joe Conway <mail@joeconway.com>
0 siblings, 0 replies; 3+ messages in thread
From: jack @ 2003-03-10 04:48 UTC (permalink / raw)
To: pgsql-sql; Joe Conway <mail@joeconway.com>
Thanks Joe. Yes, that is exactly what I need.
Jack
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-03-10 04:48 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-03-10 01:21 About Create Type jack <datactrl@tpg.com.au>
2003-03-10 01:33 ` Joe Conway <mail@joeconway.com>
2003-03-10 04:48 ` jack <datactrl@tpg.com.au>
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