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" <[EMAIL PROTECTED]> ���g��l��s�D
:9qd0j0$1gc3$[EMAIL PROTECTED]
> >
> > 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 4: Don't 'kill -9' the postmaster
