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
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
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
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
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.
