Naomi,
try on the psql
show all;
this will print the runtime parameters.
lc_* are the ones you are looking for, I guess.
ie, set a new value.
set lc_time='en_GB';
Best wishes,
Guido
> We are looking at enabling LOCALE, on 7.3.4 and 7.4.3 Postgres
> installations, yet LOCALE is not listed u
I should have looked further. I see LOCALE is always enabled.
From the postgresql change history. The --enable-locale compile option
was removed and locale support is now permanently turned on. In fact,
it looks like it cannot be turned off. For 7.3.4 onwards.
HISTORY: * Always enabl
We are looking at enabling LOCALE, on 7.3.4 and 7.4.3 Postgres
installations, yet LOCALE is not listed under the options to enable.
Anyone know?
Naomi Walker wrote:
>We are seeing some different sorting sequences (when using BETWEEN)
>amoung our various operating systems. My guess is that s
We are seeing some different sorting sequences (when using BETWEEN)
amoung our various operating systems. My guess is that some paramater
controls this, but I have yet to find where this is located.
We are using 7.3.4 on Solaris servers, and 7.3.4 and 7.4 on Red Hat Linux.
Thanks,
Naomi
--
-
