Re: to_char()??

From: missive(at)frontiernet(dot)net (Lee Harr)
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: to_char()??
Date: 2001-10-14 21:37:36
Message-ID: 9qd0j0$1gc3$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>
> 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?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-10-14 23:08:07 Re: referencial conlumn contraints and inheritance
Previous Message Josh Berkus 2001-10-14 18:54:10 Re: referencial conlumn contraints and inheritance