Re: SQL99 CONVERT() function

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: SQL99 CONVERT() function
Date: 2002-08-06 07:54:17
Message-ID: 20020806095416.A9339@zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Tue, Aug 06, 2002 at 02:55:04PM +0900, Tatsuo Ishii wrote:
> I have added SQL99's CONVERT() function. docs and regression tests
> also updated. Our own convert() functions can also be used. Example
> usage of CONVERT():
>
> convert('PostgreSQL' using iso8859_1_to_utf8)
^^^^^
What is it? Is it really in standard? Sorry, but it seems
strange. What 'ISO8859-1' as name?

CAST( int_as_char ) ? :-)

.... CONVERT('PostgreSQL' USING 'ISO8859-1' TO 'UTF8')

Karel

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Justin Clift 2002-08-06 08:07:38 [Fwd: Who here is an AUUG member? (Australian Unix Users Group)]
Previous Message Dave Page 2002-08-06 07:35:21 Re: SQL99 CONVERT() function

Browse pgsql-patches by date

  From Date Subject
Next Message Dennis Bjorklund 2002-08-06 08:14:50 swedish translation of psql
Previous Message Tatsuo Ishii 2002-08-06 06:57:35 Re: SQL99 CONVERT() function