> 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