pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: string function
2+ messages / 2 participants
[nested] [flat]
* string function
@ 2007-11-21 19:30 gunartha <gunartha.nyoman@ptjas.co.id>
2007-11-21 03:53 ` Re: string function Frank Bax <fbax@sympatico.ca>
0 siblings, 1 reply; 2+ messages in thread
From: gunartha @ 2007-11-21 19:30 UTC (permalink / raw)
To: pgsql-php
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: string function
2007-11-21 19:30 string function gunartha <gunartha.nyoman@ptjas.co.id>
@ 2007-11-21 03:53 ` Frank Bax <fbax@sympatico.ca>
0 siblings, 0 replies; 2+ messages in thread
From: Frank Bax @ 2007-11-21 03:53 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-11-21 19:30 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-21 19:30 string function gunartha <gunartha.nyoman@ptjas.co.id>
2007-11-21 03:53 ` Frank Bax <fbax@sympatico.ca>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox