I'm using version 7.3 of postgres and when I issue the following command
select author, sort_author from itemsbyauthor where sort_author like 'tan%';
I get the following results:
Author sort_author
Tan, Weihong| tan, weihong
Tang, S. C.
I'll try this question again.
_
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jose Blanco
Sent: Thursday, May 03, 2007 4:12 PM
To: pgsql-bugs@postgresql.org
Subject: [BUGS] order by question.
I'm using version 7.3 of postgres and when I issue the followi
ne
Sent: Friday, May 04, 2007 2:24 PM
To: Jose Blanco
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] order by question.
"Jose Blanco" <[EMAIL PROTECTED]> writes:
> I'll try this question again.
The answer is the same as before: you didn't specify an ORDER BY c
I'm not sure what you mean by "C" and how do I change this?
-Original Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]
Sent: Friday, May 04, 2007 3:38 PM
To: Jose Blanco
Cc: 'Tom Lane'; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] order by question.