X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id CDF499DC989 for ; Sun, 22 Jan 2006 16:13:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39499-07 for ; Sun, 22 Jan 2006 16:13:59 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id BEDDC9DC981 for ; Sun, 22 Jan 2006 16:13:56 -0400 (AST) Received: from hosts.rhea.solnet (0x50c60afe.vgnxx3.adsl-dhcp.tele.dk [80.198.10.254]) by svr4.postgresql.org (Postfix) with ESMTP id 1D0725AF1C6 for ; Sun, 22 Jan 2006 20:13:57 +0000 (GMT) Received: from io.solnet (io.solnet [10.1.1.8]) (authenticated bits=0) by hosts.rhea.solnet (8.13.0/8.13.0) with ESMTP id k0ML1IWA005357 for ; Sun, 22 Jan 2006 22:01:18 +0100 Date: Sun, 22 Jan 2006 21:13:51 +0100 From: "Jesper K. Pedersen" To: pgsql-sql@postgresql.org Subject: How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ? Message-ID: <20060122211351.371f20d8@io.solnet> X-Mailer: Sylpheed-Claws 1.9.100 (GTK+ 2.6.10; i386-redhat-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: clamd / ClamAV version 0.74, clamav-milter version 0.74a on rhea X-Virus-Status: Clean X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200601/140 X-Sequence-Number: 23929 I am have some difficulties converting the Microsoft field of type YESNO (which is a simple boolean true/false) to something that is compatible with PostgreSQL. I have tried with both boolean, bit(1) and even integer to try and get it to work but with no success - Access see the boolean and bit(1) as "text" fields. This mean that I am not able to use the built-in form input fields for the "YESNO" field type. Anyone with any ideas on how to get around this? Thank's Jesper K. Pedersen