Thread: Encoding Sort order

Encoding Sort order

From
Richard Broersma Jr
Date:
I understand that it is possible for tables from different databases that have the exact same data
but different Encoding can sort rows in differet orders.

Could this allow affect the order that triggers and rules are fired?

Regards,
Richard Broersma Jr.

Re: Encoding Sort order

From
Tom Lane
Date:
Richard Broersma Jr <rabroersma@yahoo.com> writes:
> I understand that it is possible for tables from different databases that have the exact same data
> but different Encoding can sort rows in differet orders.

> Could this allow affect the order that triggers and rules are fired?

AFAIK, no --- those names are sorted according to strcmp() regardless
of locale.

            regards, tom lane

Re: Encoding Sort order

From
"CAJ CAJ"
Date:
On 5/31/07, Richard Broersma Jr <rabroersma@yahoo.com> wrote:
I understand that it is possible for tables from different databases that have the exact same data
but different Encoding can sort rows in differet orders.

Could this allow affect the order that triggers and rules are fired?