CJ -
You might want to join the NOVICE list and post this kind of question there,
should you have more.
> 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
SUBSTR(data, 1, 3)
See "Functions And Operators" in the online docs for more.
--
-Josh BerkusAglio Database SolutionsSan Francisco