Home > mailing lists

Re: select 3 characters - Mailing list pgsql-sql

From	A.Bhuvaneswaran
Subject	Re: select 3 characters
Date	May 16, 2003 06:46:16
Msg-id	Pine.LNX.4.44.0305131124340.2352-100000@Bhuvan.bksys.co.in Whole thread Raw
In response to	select 3 characters ("Cyber Join" <cyberjoin@linuxmail.org>)
List	pgsql-sql

Tree view

> I try this but doesn't work
> 
> "SELECT left(data,3) AS value FROM table;"
> 

Left? Substr is the function to extract a substring. substr(data, 1, 3) 
would solve your problem.

regards,
bhuvaneswaran

pgsql-sql by date:

From: Jeff Eckermann
Date: 15 May 2003, 21:13:08
Subject: Re: select 3 characters

From: Christoph Haller
Date: 16 May 2003, 07:41:47
Subject: Re: See Temp Table from Trigger

Re: select 3 characters - Mailing list pgsql-sql

Previous

Next