Re: ORDER BY question

I know that on my mailing lists the software I use to make web archives would pick up the reply as a reply even if you changed all of the headers information that you can see. Also on my lists I force the reply to only go to the list.. and not the user.. I'm not sure why they do both here.. but trust me.. the information you get is worth a couple of duplicate messages.

Travis

-----Original Message-----
From: Luis H. [mailto:pgsql-novice(at)geekhouse(dot)no-ip(dot)com]
Sent: Monday, September 01, 2003 8:57 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] ORDER BY question

Thanks for the info! Group by should do the trick.

Why does replying to an unrelated message create an issue, btw? I changed
the subject, headers and contents of the e-mail. Or at least I thought I
did!

Also, why do people reply to both the message sender and the mailing list?
Doesn't it just arrive duplicated in the sender's mailbox.

Cheers,
- Luis
----- Original Message -----
From: "Bruno Wolff III" <bruno(at)wolff(dot)to>
To: "Luis H." <pgsql-novice(at)geekhouse(dot)no-ip(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Sent: Monday, September 01, 2003 3:04 AM
Subject: Re: [NOVICE] ORDER BY question

> Please don't start new topics by by replying to unrelated messages.
>
> On Sun, Aug 31, 2003 at 21:44:12 -0400,
> "Luis H." <pgsql-novice(at)geekhouse(dot)no-ip(dot)com> wrote:
> > I have two tables, table A contains users (id, username, password) , and
> > table B contains a row that signifies the 'owner' of each particular
entry,
> > referencing an id in A.
> >
> > What I want to do is do a query where I order table B by owner, but
> > alphabetically by username. The problem, obviously, is that table B only
> > contains id's (numbers, indexing to A), which don't correspond to the
> > alphabetical order of the usernames.
>
> You should do a join on A and B and then you can order the output by
> fields in both A and B.
>

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org