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 C038353B5B for ; Thu, 31 Mar 2005 05:17:05 +0100 (BST) 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 85426-06 for ; Thu, 31 Mar 2005 04:17:03 +0000 (GMT) Received: from alumni.cyut.edu.tw (alumni.cyut.edu.tw [163.17.7.196]) by svr1.postgresql.org (Postfix) with ESMTP id D255053B59 for ; Thu, 31 Mar 2005 05:17:01 +0100 (BST) Received: from cyut.edu.tw (alumni [163.17.7.196]) by alumni.cyut.edu.tw (8.12.11/8.12.11) with ESMTP id j2V4M70S007138 for ; Thu, 31 Mar 2005 12:22:07 +0800 From: "Lin Kun Hsin" To: "pgsql-sql" Subject: Re: delphi access question Date: Thu, 31 Mar 2005 12:22:07 +0800 Message-Id: <20050331035639.M76695@cyut.edu.tw> X-Mailer: Open WebMail 2.41 20041118 X-OriginatingIP: 163.17.28.64 (s9154083) MIME-Version: 1.0 Content-Type: text/plain; charset=big5 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.076 tagged_above=0 required=5 tests=AWL, FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200503/406 X-Sequence-Number: 20885 hello I can run your sql statement in PgAdmin,too. so your statement should be OK! Can you post more example about add to result, let us have idea about your question. I think you can try to set char(1) to char(2), try it will useful.. -- http://alumni.cyut.edu.tw Open WebMail Project (http://openwebmail.org)