On Mon, 15 Oct 2001 09:56:26 +0800, guard <[EMAIL PROTECTED]> 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 ":"
> Works for me on 7.1.2 and pre-7.2 What version are you using? select version(); That still leaves it unclear in my mind what exactly you want from your query. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
