Re: [BUGS] order by question.

2007-05-04 Thread Ennio-Sr
* Ennio-Sr <[EMAIL PROTECTED]> [040507, 23:52]: > * Jose Blanco <[EMAIL PROTECTED]> [040507, 14:28]: > > This second time I did, see > > > > select author, sort_author from itemsbyauthor where sort_author like 'tan%' > > order by 2; > > > Hi Jose, > have you tried to modify your query as others s

Re: [BUGS] order by question.

2007-05-04 Thread Stephan Szabo
On Fri, 4 May 2007, Jose Blanco wrote: > I'm not sure what you mean by "C" and how do I change this? It's a locale name. The ordering is effectively byte order ordering, while many other locales like en_US have more interesting sorting rules. IIRC, the locale can only be set at initdb time curren

Re: [BUGS] order by question.

2007-05-04 Thread Ennio-Sr
* Jose Blanco <[EMAIL PROTECTED]> [040507, 14:28]: > This second time I did, see > > select author, sort_author from itemsbyauthor where sort_author like 'tan%' > order by 2; > > > "order by 2" > > Or am I not understanding something? Hi Jose, have you tried to modify your query as others sugg

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.

Re: [BUGS] order by question.

2007-05-04 Thread Stephan Szabo
On Fri, 4 May 2007, Jose Blanco wrote: > This second time I did, see > > select author, sort_author from itemsbyauthor where sort_author like 'tan%' > order by 2; > > > "order by 2" > > Or am I not understanding something? One issue you might not realize is that the sort order for some locales i

Re: [BUGS] order by question.

2007-05-04 Thread Peter Eisentraut
Jose Blanco wrote: > This second time I did, see > > select author, sort_author from itemsbyauthor where sort_author like > 'tan%' order by 2; No, your posts didn't contain that query. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)

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 Tom Lane
"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 clause, therefore there is no reason to expect any particular output ordering. Whatever ordering you might happen to see is an implementation artifact.

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-03 Thread Douglas Toltzman
Your query doesn't appear to include an "order by" clause. The results won't be sorted without an "order by". On May 3, 2007, at 4:12 PM, Jose Blanco wrote: I’m using version 7.3 of postgres and when I issue the following command select author, sort_author from itemsbyauthor where sort_

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