Skip site navigation (1) Skip section navigation (2)

Is "CREATE DOMAIN" in 6.3 ??

From: al dev <aldevpgsql(at)yahoo(dot)com>
To: pgsql-questions(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Is "CREATE DOMAIN" in 6.3 ??
Date: 1998-02-28 16:57:48
Message-ID: 19980228165748.29306.rocketmail@send1b.yahoomail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi:
Is create domain command implemented in 6.3??
I am trying to use
  create domain employed as char(10)
  check (
value = "YES" or
value = "NO" or
value = "RETIRED" or
value = "DISABLED" or
value is NULL
);
in SQL scripts but is failing in 6.2.1 postgresql.

I can find work around BUT there are tons of create domains in my SQL
scripts and will be very tedious.
By the way, create domain is in defined in SQL 92
see this chapter 42 in
http://sunsite.unc.edu/LDP/HOWTO/Database-HOWTO.html

al
"This world is wasting billions of dollars and millions manhours
re-inventing the TECHNOLOGY WHEELS!!"
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com


Responses

pgsql-hackers by date

Next:From: The Hermit HackerDate: 1998-02-28 19:03:48
Subject: Re: [HACKERS] Coasting to 6.3 release
Previous:From: Michael J. RoganDate: 1998-02-28 16:52:08
Subject: Re: [HACKERS] Rule plan size for views?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group