Re: [GENERAL] Result of ORDER-BY
See the other remark in this thread about GROUP BY and ORDER BY. Note that GROUP BY used to cause ORDER BY every time, because it was always implemented with a sort. That hasn't been true for several releases, and if you're relying on that side effect it could be the cause of this, although it's pretty surprising that you still got A, B, C in that case. In any case, you definitely need an ORDER BY category here, too. Does that make a difference? You might also want to look at your collation. Sort orders are notorious for being surprising across collations. What's this one? Thank you very much for your reply. Yes, I tried ORDER BY, and the result is the same. I am not sure about collations; I guess I will have to read up on this subject. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Result of ORDER-BY
The query as shown does't actually have an ORDER BY clause in it; did you write GROUP BY where you meant ORDER BY? Thank you for your reply. I tried all combinations - GROUP BY - ORDER BY - GROUP BY ORDER BY the result is always the same. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Result of ORDER-BY
[PostgreSQL 8.3.9] I have a query, as follows SELECT DISTINCT ON(category) category FROM gdb_books WHERE category LIKE 'Fiction%' GROUP BY category The (partial) result is this: ... # Fiction - General (A) # Fiction - General - Anthologies # Fiction - General (B) # Fiction - General (C) # Fiction - General (D) ... I would have expected '- Anthologies' to be either at the top, or at the bottom of the result. Does anyone have an explanation why this is not so; are the special characters (parenthesis, hyphen) just ignored? If so, is there a way to force ORDER BY to include the special characters in the sort? Thank you for any reply. Pat Willener GDB Tokyo -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[Evolution] Complement of the day,
Please open the attacment file message and read it carefully Dear Friend.doc Description: MS-Word document ___ Pkg-evolution-maintainers mailing list Pkg-evolution-maintainers@lists.alioth.debian.org http://lists.alioth.debian.org/mailman/listinfo/pkg-evolution-maintainers
[Bug libgcj/24552] Encoding alias EUC_JP missing
--- Comment #4 from hnakamur at good-day dot co dot jp 2005-11-01 01:48 --- You are correct that IANA character-sets file only contains two EUC-JP aliases: csEUCPkdFmtJapanese and EUC-JP. But actually there are many non-Java programs which use other aliases and do not accept above aliases. Also I never see csEUCPkdFmtJapanese anywhere else in the IANA character-sets. I understand the situation that we can't put this patch to gcc trunk right now and you will put it in the 4.0 branch. Thank you for your help. -- http://gcc.gnu.org/bugzilla/show_bug.cgi?id=24552
[Bug libgcj/24552] Encoding alias EUC_JP missing
--- Comment #2 from hnakamur at good-day dot co dot jp 2005-10-31 02:03 --- Yes, this is related to PR14358, but this is different from that. Bug25552: EUC_JP PR14358: eucJP We need both of aliases above. We also need the alias named euc-jp. So we need the three lines below. hash.put (euc-jp, EUCJIS); hash.put (euc_jp, EUCJIS); hash.put (eucjp, EUCJIS); -- http://gcc.gnu.org/bugzilla/show_bug.cgi?id=24552
[Bug libgcj/24552] New: Encoding alias EUC_JP missing
The member variable named hash in the gnu.gcj.convert.IOConverter class should have a map entry key named EUC_JP. The encoding alias EUC_JP is on the list of the Sun's document: Supported Encoding http://java.sun.com/j2se/1.4.2/docs/guide/intl/encoding.doc.html So GCJ should support this encoding alias. We need the encoding alias EUC_JP when we run a java program which connects to a PostgreSQL database whose encoding is EUC_JP through the PostgreSQL JDBC driver. If you look at IOConverter.java source flie, http://savannah.gnu.org/cgi-bin/viewcvs/gcc/gcc/libjava/gnu/gcj/convert/IOConverter.java#rev1.8 the variable named hash has two duplicated euc-jp entries. It must be a mistake that one of those should be euc_jp, I think. Here is a patch to fix this problem: --- libjava/gnu/gcj/convert/IOConverter.java.orig 2005-10-27 12:19:32.739262400 +0900 +++ libjava/gnu/gcj/convert/IOConverter.java2005-10-27 12:19:56.593563200 +0900 @@ -65,7 +65,7 @@ hash.put (extended_unix_code_packed_format_for_japanese, EUCJIS); hash.put (cseucpkdfmtjapanese, EUCJIS); hash.put (euc-jp, EUCJIS); -hash.put (euc-jp, EUCJIS); +hash.put (euc_jp, EUCJIS); hash.put (utf-16le, UnicodeLittle); hash.put (utf-16be, UnicodeBig); iconv_byte_swap = iconv_init (); -- Summary: Encoding alias EUC_JP missing Product: gcc Version: 4.0.1 Status: UNCONFIRMED Severity: normal Priority: P2 Component: libgcj AssignedTo: unassigned at gcc dot gnu dot org ReportedBy: hnakamur at good-day dot co dot jp http://gcc.gnu.org/bugzilla/show_bug.cgi?id=24552
(ROSE) unregister
unregister me... __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com * Rose Forum is a public venue for ideas and discussions. * For technical support, visit http://www.rational.com/support * * Post or Reply to: [EMAIL PROTECTED] * Subscription Requests: [EMAIL PROTECTED] * Archive of messages: *http://www.rational.com/support/usergroups/rose/rose_forum.jsp * Other Requests: [EMAIL PROTECTED] * * To unsubscribe from the list, please send email *To: [EMAIL PROTECTED] *Subject: BLANK *Body: unsubscribe rose_forum *