pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: string function
2+ messages / 2 participants
[nested] [flat]

* Re: string function
@ 2007-11-21 03:53  Frank Bax <fbax@sympatico.ca>
  parent: gunartha <gunartha.nyoman@ptjas.co.id>
  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

* string function
@ 2007-11-21 19:30  gunartha <gunartha.nyoman@ptjas.co.id>
  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


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