Problem in order by

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

I make a dump from a database in cygwin in Windows to PG 7.3 in linux Red
Hat 9.
But I have a problem with 'order by'.

The query is 'select prodes from es002 where prodes like 'TELHA%' order by
1'

In the Cygwin, the return is correct:

                       prodes
----------------------------------------------------
 TELHA FRANCESA CAMBORIU
 TELHA PORTUGUESA SAO CRISTOVAO
 TELHA ROMANA LEONEL PEREIRA
 TELHA TRANSPARENTE FRANCESA
 TELHA TRANSPARENTE PORTUGUESA
 TELHA TRANSPARENTE ROMANA
 TELHA ZINCO 1 1/2 P/POSTE TELHADO
 TELHAO FRANCES SAO CRISTOVAO                    *
 TELHAO ROMANO SAO CRISTOVAO-GOIVA      *


But in Linux the return is:

                       prodes
----------------------------------------------------
 TELHA FRANCESA CAMBORIU
 TELHAO FRANCES SAO CRISTOVAO                    *
 TELHAO ROMANO SAO CRISTOVAO-GOIVA      *
 TELHA PORTUGUESA SAO CRISTOVAO
 TELHA ROMANA LEONEL PEREIRA
 TELHA TRANSPARENTE FRANCESA
 TELHA TRANSPARENTE PORTUGUESA
 TELHA TRANSPARENTE ROMANA
 TELHA ZINCO 1 1/2 P/POSTE TELHADO

I already executed vacuumbd and reindex database but nothing.

Somebody could help me?

Tks
Reuly Mendes



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux