Re: select 3 characters

From: "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>
To: Cyber Join <cyberjoin(at)linuxmail(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: select 3 characters
Date: 2003-05-13 05:57:33
Message-ID: Pine.LNX.4.44.0305131124340.2352-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message A.Bhuvaneswaran 2003-05-13 08:12:20 Re: Why this query does not work?
Previous Message Tom Lane 2003-05-12 21:53:43 Re: Why this query does not work?