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