pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Szabo Zoltan <col@mportal.hu>
To: pgsql-sql@postgresql.org
Subject: Re: to_char()??
Date: Mon, 15 Oct 2001 16:05:16 +0200
Message-ID: <3BCAED1C.3090306@mportal.hu> (raw)
References: <9qb2lj$13lv$1@news.tht.net>
	<9qd0j0$1gc3$1@news.tht.net>
	<9qdfnh$1jte$1@news.tht.net>

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@frontiernet.net> ¼¶¼g©ó¶l¥ó·s»D
> :9qd0j0$1gc3$1@news.tht.net...
> 
>>>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?
>>
>>
> 
> 




view thread (6+ messages)  latest in thread

Message-ID: <3BCAED1C.3090306@mportal.hu>
Permalink:  ../3BCAED1C.3090306@mportal.hu/
Also on:    postgresql.org/message-id/3BCAED1C.3090306@mportal.hu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: col@mportal.hu
  Subject: Re: to_char()??
  In-Reply-To: <3BCAED1C.3090306@mportal.hu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox