On Thu, 29 Nov 2001, Kristian Lance wrote: > The server is running: > > PostgreSQL version 7.0.2 > RedHat Linux 6.2 > > When using ORDER BY in an SQL statement where the data type is varchar and > the data are unix directory paths, the forward slashes (/) are ignored, > causing the results to be returned in the incorrect order.
Are you running with locale enabled and what are the LC_* settings you are starting the server with? ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
