X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 166E43CC42C for ; Fri, 17 Dec 2004 12:56:06 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48618-05 for ; Fri, 17 Dec 2004 12:55:52 +0000 (GMT) Received: from sharp.noc24x7.com (unknown [69.56.128.138]) by svr1.postgresql.org (Postfix) with ESMTP id A59BB3CC944 for ; Fri, 17 Dec 2004 12:55:55 +0000 (GMT) Received: from [61.3.110.149] (helo=thenilgiris.com) by sharp.noc24x7.com with esmtpa (Exim 4.43) id 1CfHeE-0004pd-8v; Fri, 17 Dec 2004 18:25:55 +0530 Received: from localhost (localhost [[UNIX: localhost]]) by thenilgiris.com (8.11.2/8.11.2) id iBHCqnE31745; Fri, 17 Dec 2004 18:22:49 +0530 Content-Type: text/plain; charset="iso-8859-1" From: Kenneth Gonsalves To: "D'Arcy J.M. Cain" Subject: Re: sql can i substitute Date: Fri, 17 Dec 2004 18:22:48 +0530 X-Mailer: KMail [version 1.2] Cc: pgsql-sql@postgresql.org References: <0412171655451H.06834@thenilgiris.com> <20041217074257.42a44460.darcy@druid.net> In-Reply-To: <20041217074257.42a44460.darcy@druid.net> MIME-Version: 1.0 Message-Id: <0412171822481N.06834@thenilgiris.com> Content-Transfer-Encoding: 8bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - sharp.noc24x7.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - thenilgiris.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.19 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200412/121 X-Sequence-Number: 19741 On Friday 17 December 2004 06:12 pm, D'Arcy J.M. Cain wrote: > An alternative to Andreas' suggestion would be to create a simple lookup > table and join them. This is good if the real life example can get > larger and/or the list can change and you don't want to modify code > every time it does. yes, but in this case the list wont change, and i'm trying to port mysql to pgsql without disturbing as far as possible the mysql queries. basically replacing some 'set' and 'enum' datatypes - one table has six of thes, and adding six tables is not on kg