... order by table1.name || table2.name
The sorting would then be performed on both of the them as though they were one column.
Adam Ruth
On Jan 2, 2004, at 8:04 PM, Michael Glaesemann wrote:
On Jan 2, 2004, at 8:55 PM, Andy Lewis wrote:Yes, I understand this but, I would like to have the results of both "table1.name, table2.name" sorted as one column.
Is this possible?
So you want one column of name, including names from both table1 and table2? In that case, you need to use UNION, I believe. If it's something else, I'm not sure I understand what you're asking. Perhaps you could include a sample of what you're getting, along with what you'd like to see?
Michael Glaesemann grzm myrealbox com
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
