| 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 |
| Thread: | |
| 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 | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2007-11-21 04:33:56 | Re: VB ADODB .Open failing |
| Previous Message | Finn Lassen | 2007-11-21 00:54:52 | VB ADODB .Open failing |