> > pg_available_encodings([INTEGER how]) RETURNS setof TEXT
> >
> > where how is
> >
> > 0(or omitted): returns all available encodings
> > 1: returns encodings in backend
> > 2: returns encodings in frontend
> >
> > Comments?
>
> 3: returns encodings of both backend and frontend
>
> Why both? To compare and match upon the need.
> If by 0 (ALL) you meant the same, then please ignore my comment.
You are correct. We don't need how=3.
> My question is now how many BE's/FE's would you return encodings for?
I don't quite understand your question. What I thought were something
like this:
SELECT pg_available_encodings();
pg_available_encodings
----------------------
SQL_ASCII
EUC_JP
EUC_CN
EUC_KR
EUC_TW
UNICODE
MULE_INTERNAL
LATIN1
LATIN2
LATIN3
LATIN4
LATIN5
KOI8
WIN
ALT
SJIS
BIG5
WIN1250
BTW, another question comes to my mind. Why don't we make available
this kind of information by ordinaly tables or views, rather than by
functions? It would be more flexible and easy to use.
--
Tatsuo Ishii