| Lists: | pgsql-php |
|---|
| From: | Frank Bax <fbax(at)sympatico(dot)ca> |
|---|---|
| To: | pgsql-php(at)postgresql(dot)org |
| Subject: | Re: string function |
| Date: | 2007-11-21 03:53:54 |
| Message-ID: | 4743ABD2.2010009@sympatico.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-php |
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-string.html
Perhaps you meant to use ...
select substr(kd_aln,1,2) as code from airlin
| From: | "gunartha" <gunartha(dot)nyoman(at)ptjas(dot)co(dot)id> |
|---|---|
| To: | <pgsql-php(at)postgresql(dot)org> |
| Subject: | string function |
| Date: | 2007-11-21 19:30:56 |
| Message-ID: | 014701c82c75014701c82c75$0d6fb6c0$0f0010b2@gunarthad6fb6c0014701c82c75$0d6fb6c0$0f0010b2@gunarthaf0010b2@gunartha |
| Views: | Raw Message | postgresql : | Download mbox | Resend email |
| Lists: | Postg스포츠 토토SQL : Postg스포츠 토토SQL 메일 링리스트 : 2007-11-21 이후 PGSQL-PHP 19:30 |
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