Cum a fost initializat clusterul postgres ? Cu ce optiune pt collate ma intereseaza ? pt ca : postgres$ initdb -D /usr/local/pgsql/data
The database cluster will be initialized with locale de_DE. This locale setting will prevent the use of indexes for pattern matching operations. If that is a concern, rerun initdb with the collation order set to "C". For more information see the Administrator's Guide. http://www.postgres.org/docs/7.3/static/creating-cluster.html On Thu, 2003-11-06 at 19:53, Alex 'CAVE' Cernat wrote: > salut > > incerc sa dau un select in postgres ordonat dupa un varchar; ordonarea > lu peshte (si pe 7.1 si pe 7.3.x), ceva in genul telefoanelor nokia > adicatelea uite aici stil: > > select * from names order by name; > id | name > ----+------------------- > 1 | alex > 6 | alexsefacedeteste > 3 | alex-test > 4 | alextesteaza > 2 | alexunu > 5 | alexzzzzz > > parca pur si simplu ignora '-' de vaka ce e, pentru ca nu stiu in ce > limba ar fi ordonata expresia de mai sus (nu e nici alfabetic, nici > ascii, nimic) > > intrebarea e: ce s-ar putea face ? > > Alex > > --- > Detalii despre listele noastre de mail: http://www.lug.ro/ > > -- Attached file included as plaintext by Ecartis -- -- File: signature.asc -- Desc: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQA/qocl2rUJhEVVRu8RAjLbAJ96WlVgUUzmYhYvl/EZwXR31LvK5ACfWtvB QeNSLI1P3BX99bhr8ZiM+Nw= =fQmP -----END PGP SIGNATURE----- --- Detalii despre listele noastre de mail: http://www.lug.ro/
