X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 20E6A47677D for ; Thu, 15 May 2003 17:32:27 -0400 (EDT) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with ESMTP id 18462-01 for ; Thu, 15 May 2003 17:31:56 -0400 (EDT) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id A0C694768EB for ; Thu, 15 May 2003 16:58:51 -0400 (EDT) Received: from [216.135.165.74] (HELO temoku) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3036757; Thu, 15 May 2003 13:58:55 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: "Cyber Join" , pgsql-sql@postgresql.org Subject: Re: select 3 characters Date: Thu, 15 May 2003 13:58:27 -0700 User-Agent: KMail/1.4.3 References: <20030515200526.31852.qmail@linuxmail.org> In-Reply-To: <20030515200526.31852.qmail@linuxmail.org> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200305151358.27937.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/338 X-Sequence-Number: 13503 CJ - You might want to join the NOVICE list and post this kind of question there= ,=20 should you have more. > Hi I need select the first 3 characters from a table >=20 > I try this but doesn't work >=20 > "SELECT left(data,3) AS value FROM table;" >=20 > i see the left function doesn't work what is the similar function in=20 postgresql SUBSTR(data, 1, 3) See "Functions And Operators" in the online docs for more. --=20 -Josh Berkus Aglio Database Solutions San Francisco