dear sir,
when i run a query with order by customer_name i am
getting the following result(ex.).
AA
A B
AC
i want it to be
A B
AA
AB
It's because of locales. Some special characteres are removed when
sorting using locales. I'm not sure, but probably only "C" locale will
give results you need.
OK, thanks. That seems to make sense.
regards
Iain
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Iain" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, December 02, 2004 11:54 AM
Subject: Re: [SQL] invalid 'having' clause
sad wrote:
On Wednesday 01 December 2004 18:42, Tom Lane wrote:
Christoph Haller <[EMAIL PROTECTED]> writes:
Please, could someone point me to the right list
or tell me how to do a "SET AUTOCOMMIT TO OFF" within libpq.
libpq does not have any support for that.
Does this mean libpq calls always unc
Simon Moses wrote:
dear sir,
when i run a query with order by customer_name i am
getting the following result(ex.).
AA
A B
AC
i want it to be
A B
AA
AB
Sorting is down to your locale (the LC_xxx configuration settings). This
is set when you initdb your database. It looks to me like you want "C"
s
On 2004-12-02, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Kevin B." <[EMAIL PROTECTED]> writes:
>> Select a.i, b.i
>> from t as a
>> left join t as b on a.i = b.i
>> where a.n = 'a' and b.n = 'b' and b.i is null
>
> This can't succeed since the b.n = 'b' condition is guaranteed to fail
> when b.* is nu
