pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Sorting Sequence
4+ messages / 2 participants
[nested] [flat]

* Sorting Sequence
@ 2004-09-15 15:35  Naomi Walker <nwalke@eldocomp.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Naomi Walker @ 2004-09-15 15:35 UTC (permalink / raw)
  To: pgsql-admin

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

-- 
-------------------------------------------------------------------------
Naomi Walker                          Chief Information Officer
Eldorado Computing, Inc.              nwalker@eldocomp.com 602-604-3100 
-------------------------------------------------------------------------
Freedom is not worth having if it does not include the freedom to make
mistakes.      -Mahatma Gandhi
------------------------------------------------------------------------- 

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Sorting Sequence
@ 2004-09-15 17:20  Naomi Walker <nwalke@eldocomp.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Naomi Walker @ 2004-09-15 17:20 UTC (permalink / raw)
  To: nwalker@eldocomp.com <nwalker@eldocomp.com>; +Cc: pgsql-admin

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


-- 
-------------------------------------------------------------------------
Naomi Walker                          Chief Information Officer
Eldorado Computing, Inc.              nwalker@eldocomp.com 602-604-3100 
-------------------------------------------------------------------------
Freedom is not worth having if it does not include the freedom to make
mistakes.      -Mahatma Gandhi
------------------------------------------------------------------------- 

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Sorting Sequence
@ 2004-09-15 17:24  Naomi Walker <nwalke@eldocomp.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Naomi Walker @ 2004-09-15 17:24 UTC (permalink / raw)
  To: nwalker@eldocomp.com <nwalker@eldocomp.com>; +Cc: pgsql-admin

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 enable locale in compile, remove --enable-locale 
option

>  
>


-- 
-------------------------------------------------------------------------
Naomi Walker                          Chief Information Officer
Eldorado Computing, Inc.              nwalker@eldocomp.com 602-604-3100 
-------------------------------------------------------------------------
Freedom is not worth having if it does not include the freedom to make
mistakes.      -Mahatma Gandhi
------------------------------------------------------------------------- 

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Sorting Sequence
@ 2004-09-15 17:29  G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
  0 siblings, 0 replies; 4+ messages in thread

From: G u i d o B a r o s i o @ 2004-09-15 17:29 UTC (permalink / raw)
  To: nwalker@eldocomp.com; pgsql-admin

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 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 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
> >
> >  
> >
> 
> 
> -- 
> -------------------------------------------------------------------------
> Naomi Walker                          Chief Information Officer
> Eldorado Computing, Inc.              nwalker@eldocomp.com 602-604-3100 
> -------------------------------------------------------------------------
> Freedom is not worth having if it does not include the freedom to make
> mistakes.      -Mahatma Gandhi
> ------------------------------------------------------------------------- 
> 
> -- CONFIDENTIALITY NOTICE --
> 
> This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2004-09-15 17:29 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-15 15:35 Sorting Sequence Naomi Walker <nwalke@eldocomp.com>
2004-09-15 17:20 Re: Sorting Sequence Naomi Walker <nwalke@eldocomp.com>
2004-09-15 17:24 Re: Sorting Sequence Naomi Walker <nwalke@eldocomp.com>
2004-09-15 17:29 Re: Sorting Sequence G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox