Re: to_char()?? Works for me.

Works for me.

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

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

On Mon, 15 Oct 2001 14:56, 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 ":"