> > 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?