Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 644B92E0048 for ; Tue, 20 Nov 2007 22:59:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 30015-01 for ; Tue, 20 Nov 2007 22:59:40 -0400 (AST) Received: from mail.ptjas.co.id (unknown [202.152.3.67]) by postgresql.org (Postfix) with ESMTP id 9F2EE2E0045 for ; Tue, 20 Nov 2007 22:59:49 -0400 (AST) Received: from [178.16.0.15] (helo=gunartha) by mx1.ptjas.co.id with smtp (Exim 4.43) id 1Iug8x-0006Mo-E5; Wed, 21 Nov 2007 10:20:56 +0700 Message-ID: <00fb01c82c6f$fa3b6e50$0f0010b2@gunartha> From: "gunartha" To: , Subject: string function Date: Wed, 21 Nov 2007 10:54:42 -0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00F8_01C82C2C.EB75FAE0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3138 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.486 tagged_above=0 required=5 tests=AWL=0.195, BAYES_50=0.001, DATE_IN_FUTURE_12_24=2.189, HTML_MESSAGE=0.001, RDNS_NONE=0.1 X-Spam-Level: ** X-Archive-Number: 200711/21 X-Sequence-Number: 9236 This is a multi-part message in MIME format. ------=_NextPart_000_00F8_01C82C2C.EB75FAE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, Having a little issue, and can't seem to figure it out! Every time I try to run this select command I get this error: select left(kd_aln,2) as code from airlin the error msg is : function left(character varying, integer) does not = exist How to resolve this problem Thank for your attention Regards Nyoman/Bali ------=_NextPart_000_00F8_01C82C2C.EB75FAE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi All,

Having a little = issue, and=20 can=92t seem to = figure it=20 out!

Every time I try = to run this select command I get this = error:

select left(kd_aln,2) as code from = airlin

the error msg is : function = left(character varying,=20 integer) does not exist

How to resolve this problem

Thank for = your=20 attention

Regards

Nyoman/Bali

------=_NextPart_000_00F8_01C82C2C.EB75FAE0--