left() in postgres

From: Peter Nixon <listuser(at)peternixon(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: left() in postgres
Date: 2002-10-25 16:31:17
Message-ID: 20021025193117.04b9e3d3.listuser@peternixon.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-10-25 16:36:24 Re: left() in postgres
Previous Message Sébastien PALLEAU 2002-10-25 16:18:14 question about seq scan and index scan