phazon <[EMAIL PROTECTED]> writes:
> I've "**" before the name in order to display them at first, but the 2
> chars "**" are ignored in the order by.
What's your lc_collate setting? In locales other than "C" this is not
at all unexpected.
regards, tom lane
--
Hi,
I've to order by q query by a column.
SELECT a.id, a.nom
FROM table a
ORDER BY a.nom;
And i've something strange. It's order like that:
5 |
8 | aaab
15 | ** aaac
6 | aaad
I've "**" before the name in order to display them at first, but the 2
chars "**" are ignored in the order b
so the only way i come around this problem is dump my db. drop the db. and
do a initdb with the right settings and run my dump on the new one?
how can i figure out which locale is set on the suse machine (i am a linux
novice, sorry)?
which locale i should set on the suse machine for use in a ge
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