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(at)frontiernet(dot)net> glsD
:9qd0j0$1gc3$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> >
> > 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?
>