left() in postgres - Mailing list pgsql-general

Hi Guys

I am trying to do a query similar to the following:

select left(field,3) from table;

Now this works in Mysql/Access etc etc, but not in postgres
(I am running PostgreSQL 7.2)

Can anyone suggest how to do this in postgres? I have a database with many
millions of records, and this functionality is essential for me.

PS. I did do a google search etc before posting.

Regards

--

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc