Re: to_char()?? Works for me.

From: Christopher Sawtell <csawtell(at)paradise(dot)net(dot)nz>
To: "guard" <guard(at)ficnet(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: to_char()?? Works for me.
Date: 2001-10-15 19:45:03
Message-ID: 20011015194504.A7DE9D21A5@deborah.paradise.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Works for me.

chris=# select substr('hi there', 3, 5)::varchar(5) as xx;
xx
-------
ther
(1 row)

chris=# select version();
version
-------------------------------------------------------------
PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)

On Mon, 15 Oct 2001 14:56, 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 ":"

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Richards 2001-10-15 22:29:51 When will vacuum go away?
Previous Message Josh Berkus 2001-10-15 19:41:52 EXECUTE ... INTO?