[BUGS] order by question.

2007-05-03 Thread Jose Blanco
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.

Re: [BUGS] order by question.

2007-05-04 Thread Jose Blanco
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

Re: [BUGS] order by question.

2007-05-04 Thread Jose Blanco
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

Re: [BUGS] order by question.

2007-05-04 Thread Jose Blanco
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.