string function

From: "gunartha" <gunartha(dot)nyoman(at)ptjas(dot)co(dot)id>
To: <pgsql-sql(at)postgresql(dot)org>, <pgsql-odbc(at)postgresql(dot)org>
Subject: string function
Date: 2007-11-21 18:54:42
Message-ID: 00fb01c82c6f$fa3b6e50$0f0010b2@gunartha
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc pgsql-sql

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Finn Lassen 2007-11-22 02:36:57 Need help with Visual Basic 6 and PostgreSQL
Previous Message Phillip Smith 2007-11-21 03:14:05 Re: string function

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas 2007-11-22 02:58:50 update on join ?
Previous Message Tom Lane 2007-11-21 18:05:26 Re: PL argument max size, and doubt