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 ":"
--
"Lee Harr" <missive@frontiernet.net> ���g���l���s�D
:9qd0j0$1gc3$1@news.tht.net...
> >
> > how to
> > select substr('hi there',3,5) as xx -->> xx change char type
> >
>
> How about:
>
> select substr('hi there', 3, 5)::varchar(5) as xx;
>
> or is this not what you mean?
>