Re: to_char()??

On Mon, Oct 15, 2001 at 09:56:26AM +0800, guard wrote:
> thanks
> 
> I have run "select substr('hi there', 3, 5)::varchar(5) as xx;"
> but get error message
> Error: ERROR:  parser: parse error at or near ":"

Upgrade your version of PostgreSQL:

test=# select substr('hi there', 3, 5)::varchar(5) as xx; xx   
------- ther
(1 row)

test=# select version();                           version                            
---------------------------------------------------------------PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled by GCC
2.95.4
(1 row)

test=# 

Ross
-- 
Ross Reedstrom, Ph.D.                                 reedstrm@rice.edu
Executive Director                                  phone: 713-348-6166
Gulf Coast Consortium for Bioinformatics              fax: 713-348-6182
Rice University MS-39
Houston, TX 77005