Hi!
I have a problem with getting the order I want on a table after new rows have been inserted. I try to simplify it...:
In other words, I have this old table: SELECT * from table ORDER BY full,part;
name full part score ---- --- --- ----- a 1 1 900 a 1 2 500
and I insert these rows into the same table: (there's nothing I can do about these 'full' values)
d 1 1 1000 d 1 2 400
And after some manipulation (that I hope someone can help me with) I want the query above (SELECT * from table ORDER BY full,part) to give this:
d 1 1 1000 d 1 2 400 a 2 1 900
Just looking at the start of your output, you are missing some rows (a/1/1) and have replaced others (a/2/1 isn't in your data).
Are you trying to summarise, and if so by what? Can you explain how you would do this by hand. Could you provide the actual table definition?
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
