From middink@indo.net.id Sun Sep  14 07:38:34 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 22979D1B52A
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 14 Sep 2003 07:38:34 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 91865-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 14 Sep 2003 04:38:03 -0300 (ADT)
Received: from smtp-1.indo.net.id (smtp-1.indo.net.id [202.159.32.91])
	by svr1.postgresql.org (Postfix) with SMTP id 53724D1B53D
	for <pgsql-sql@postgresql.org>; Sun, 14 Sep 2003 04:37:59 -0300 (ADT)
Received: (qmail 4054 invoked from network); 14 Sep 2003 14:37:56 +0700
Received: from smtp.indo.net.id (202.159.32.81)
	by smtp-1.indo.net.id with SMTP; 14 Sep 2003 14:37:56 +0700
Received: (qmail 20149 invoked from network); 14 Sep 2003 07:35:52 -0000
Received: from unknown (HELO smtp) (202.159.51.117)
	by smtp.indo.net.id with SMTP; 14 Sep 2003 07:35:52 -0000
Received: FROM middinkcomp BY smtp ; Sun Sep 14 14:47:49 2003 +0700
Message-ID: <008d01c37a8c$a17d0100$1f00a8c0@middinkcomp>
From: "Muhyiddin A.M Hayat" <middink@indo.net.id>
To: <pgsql-sql@postgresql.org>
Subject: Column Types 
Date: Sun, 14 Sep 2003 14:49:58 +0800
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_006D_01C37ACF.77BA68B0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0 tests=HTML_60_70,
	RCVD_IN_OSIRUSOFT_COM
X-Spam-Level: *
X-Archive-Number: 200309/117
X-Sequence-Number: 15095

This is a multi-part message in MIME format.

------=_NextPart_000_006D_01C37ACF.77BA68B0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

If in MySQL i'm using type EMUN what type in Postgres?
------=_NextPart_000_006D_01C37ACF.77BA68B0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>If in MySQL i'm using type EMUN what type =
in=20
Postgres?</FONT></DIV></BODY></HTML>

------=_NextPart_000_006D_01C37ACF.77BA68B0--





From olly@lfix.co.uk Sun Sep  14 07:54:01 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 57E28D1B50C
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 14 Sep 2003 07:54:01 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 90443-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 14 Sep 2003 04:53:31 -0300 (ADT)
Received: from anchor-post-34.mail.demon.net (anchor-post-34.mail.demon.net
	[194.217.242.92])
	by svr1.postgresql.org (Postfix) with ESMTP id AE938D1B4F9
	for <pgsql-sql@postgresql.org>; Sun, 14 Sep 2003 04:53:28 -0300 (ADT)
Received: from lfix.demon.co.uk ([80.177.205.209] helo=cerberus.lfix.co.uk)
	by anchor-post-34.mail.demon.net with esmtp (Exim 3.35 #1)
	id 19yRhJ-0007UQ-0Y; Sun, 14 Sep 2003 08:53:29 +0100
Received: from linda.lfix.co.uk ([192.168.1.1] ident=olly)
	by cerberus.lfix.co.uk with esmtp (Exim 4.22)
	id 19yRh8-0003yV-07; Sun, 14 Sep 2003 08:53:18 +0100
Subject: Re: Column Types
From: Oliver Elphick <olly@lfix.co.uk>
To: "Muhyiddin A.M Hayat" <middink@indo.net.id>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <008d01c37a8c$a17d0100$1f00a8c0@middinkcomp>
References: <008d01c37a8c$a17d0100$1f00a8c0@middinkcomp>
Content-Type: text/plain
Organization: LFIX Limited
Message-Id: <1063526018.18284.21.camel@linda.lfix.co.uk>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.4 
Date: Sun, 14 Sep 2003 08:53:38 +0100
Content-Transfer-Encoding: 7bit
X-LFIX-MailScanner: Found to be clean
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/118
X-Sequence-Number: 15096

On Sun, 2003-09-14 at 07:49, Muhyiddin A.M Hayat wrote:
> If in MySQL i'm using type EMUN what type in Postgres?

Use a CHECK constraint:

CREATE TABLE xxx (
   ...
   colour    TEXT   CHECK (colour IN ('red', 'green', 'blue')),
   ...
);

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "But without faith it is impossible to please him; for 
      he that cometh to God must believe that he is, and 
      that he is a rewarder of them that diligently seek 
      him."        Hebrews 11:6