Re: SQL99 CONVERT() function

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

It's a "conversion name".

From SQL99:             CONVERT <left paren> <character value expression>                 USING <form-of-use conversion
name><right paren>
 

> Sorry, but it seems
>  strange. What 'ISO8859-1' as name?

Sure, you can use '-' instead of '_' if you don't mind quoting it
with "(i.e. delimited identifier).

convert('PostgreSQL' using "iso8859-1-to-utf8")

I'm sure people don't like that way...
--
Tatsuo Ishii