Postgres Pro
Downloads
Home   >   mailing lists

select 3 characters - Mailing list pgsql-sql

From Cyber Join
Subject select 3 characters
Date
Msg-id 20030515200526.31852.qmail@linuxmail.org
Whole thread Raw
Responses Re: select 3 characters  (Josh Berkus <josh@agliodbs.com>)
Re: select 3 characters  (Richard Huxton <dev@archonet.com>)
Re: select 3 characters  ("A.Bhuvaneswaran" <bhuvansql@myrealbox.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Matt Mello
Date:
Subject: Re: "deadlock detected" documentation
Next
From: mdc@keko.com.ar
Date:
Subject: installation problem