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(at)rice(dot)edu
Executive Director phone: 713-348-6166
Gulf Coast Consortium for Bioinformatics fax: 713-348-6182
Rice University MS-39
Houston, TX 77005