Postgres Pro
Downloads
Home   >   mailing lists

Re: select 3 characters - Mailing list pgsql-sql

From Josh Berkus
Subject Re: select 3 characters
Date
Msg-id 200305151358.27937.josh@agliodbs.com
Whole thread Raw
In response to select 3 characters  ("Cyber Join" <cyberjoin@linuxmail.org>)
Responses Re: select 3 characters  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: mdc@keko.com.ar
Date:
Subject: installation problem
Next
From: Richard Huxton
Date:
Subject: Re: select 3 characters