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
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
[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)
#
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
--- 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
--- 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
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
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.
*