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