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


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to