Re: string function

gunartha wrote:
> select left(kd_aln,2) as code from airlin
>
> the error msg is : function left(character varying, integer) does not exist
>


For a complete list of string functions, look here:

http://www.postgresql.org/docs/8.2/interactive/functions-str ing.html

Perhaps you meant to use ...

select substr(kd_aln,1,2) as code from airlin


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

string function

This is a multi-part message in MIME format.

------=_NextPart_000_0144_01C82C31.FBB67EC0
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_0144_01C82C31.FBB67EC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">