Try: ::text
CoL
guard wrote:
> 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> ¼¶¼g©ó¶l¥ó·s»D
> :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?
>>
>>
>
>