order by a string

From: Stefan Leitich <steffn(at)gmx(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: order by a string
Date: 2003-10-14 19:06:51
Message-ID: 3F8C494B.3010205@gmx.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi!

i am developing with version 7.3.2 under cygwin. my production
evironment is 7.3.3 on a suse machine.
language settings (lc_...) for the server are on developing and
production machine the same, 'C'.
now i encoutered the following behaviour. i use a union select to unify
a query result with an ' (all)' entry.
i used at home a space on first character to ensure this entry will be
on top if i am ordering by the column.
it works in developing environment but it doesnt in production. in
production i got a ordering result wich ignores special chars like my
whitespace and the '(' and the all entry so comes for example after
'akk' and before 'amm'.
i dont want to have it this way!
did i miss any setting option to change this behaviour?
or do i need something like a workaround (adding another column, for
axample adding values like 0 for my special entrys and 1 for all others
so i can sort by this solumn too, to get my result?)

thanx for your help
stefan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edwin Quijada 2003-10-14 19:13:03 Error compiling pgplsh
Previous Message B.W.H. van Beest 2003-10-14 19:02:13 Re: How to list which tables are available?