Re: select 3 characters

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