Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-odbcpgsql-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

pgsql-odbc by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group