select 3 characters

From: "Cyber Join" <cyberjoin(at)linuxmail(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: select 3 characters
Date: 2003-05-15 20:05:26
Message-ID: 20030515200526.31852.qmail@linuxmail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi I need select the first 3 characters from a table

I try this but doesn't work

"SELECT left(data,3) AS value FROM table;"

i see the left function doesn't work what is the similar function in postgresql

Thanks

CJ
--
______________________________________________
http://www.linuxmail.org/
Now with e-mail forwarding for only US$5.95/yr

Powered by Outblaze

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message mdc 2003-05-15 20:23:24 installation problem
Previous Message Matt Mello 2003-05-15 19:06:36 Re: "deadlock detected" documentation