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