Postgres Pro
Downloads
Home   >   mailing lists

Re: to_char()?? - Mailing list pgsql-sql

From missive@frontiernet.net (Lee Harr)
Subject Re: to_char()??
Date
Msg-id 9qd0j0$1gc3$1@news.tht.net
Whole thread Raw
In response to to_char()??  ("guard" <guard@ficnet.net>)
List pgsql-sql
Tree view 
> 
> 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?

pgsql-sql by date:

Previous
From: Joel Burton
Date:
Subject: Re: GROUPING
Next
From: "Pat M"
Date:
Subject: Cenceptual help needed - periodic events