X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D0702476876 for ; Thu, 15 May 2003 16:53:54 -0400 (EDT) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with ESMTP id 10359-07 for ; Thu, 15 May 2003 16:53:23 -0400 (EDT) Received: from spf1.us.outblaze.com (205-158-62-158.outblaze.com [205.158.62.158]) by postgresql.org (Postfix) with SMTP id 107384768B4 for ; Thu, 15 May 2003 16:05:26 -0400 (EDT) Received: (qmail 25913 invoked from network); 15 May 2003 20:05:26 -0000 Received: from unknown (205.158.62.68) by spf1.us.outblaze.com with QMQP; 15 May 2003 20:05:26 -0000 Received: (qmail 96590 invoked from network); 15 May 2003 20:05:25 -0000 Received: from unknown (HELO ws5-2.us4.outblaze.com) (205.158.62.132) by 205-158-62-153.outblaze.com with SMTP; 15 May 2003 20:05:25 -0000 Received: (qmail 31853 invoked by uid 1001); 15 May 2003 20:05:26 -0000 Message-ID: <20030515200526.31852.qmail@linuxmail.org> Content-Type: text/plain; charset="iso-8859-1" Content-Disposition: inline Content-Transfer-Encoding: 7bit MIME-Version: 1.0 X-Mailer: MIME-tools 5.41 (Entity 5.404) Received: from [148.223.250.161] by ws5-2.us4.outblaze.com with http for cyberjoin@linuxmail.org; Fri, 16 May 2003 04:05:26 +0800 From: "Cyber Join" To: pgsql-sql@postgresql.org Date: Fri, 16 May 2003 04:05:26 +0800 Subject: select 3 characters X-Originating-Ip: 148.223.250.161 X-Originating-Server: ws5-2.us4.outblaze.com X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/336 X-Sequence-Number: 13501 Hi I need select the first 3 characters from a table I try this but doesn't work "SELECT left(data,3) AS value FROM table;" i see the left function doesn't work what is the similar function in postgresql Thanks CJ -- ______________________________________________ http://www.linuxmail.org/ Now with e-mail forwarding for only US$5.95/yr Powered by Outblaze