Received: from localhost (scrappy@localhost) by hub.org (8.8.8/8.7.5) with SMTP id IAA04670; Wed, 13 May 1998 08:43:57 -0400 (EDT) Date: Wed, 13 May 1998 08:43:57 -0400 (EDT) From: The Hermit Hacker To: pgsql-sql@postgresql.org cc: ctoudic@delices.com Subject: About the command order by Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII =================================================================== This message has been sent to a DEAD mailing list, and subsequently reforwarded to the proper one: pgsql-sql@postgresql.org =================================================================== I have a problem with the command order by with the Postgresql version 6.1 : my first query work good : $requete=3D"select ent.* , activ.* from entreprise ent, activite activ wher= e activ.numactivite =3D $activite"; But when I put an order by into, I have a bug : $requete=3D"select ent.* , activ.* from entreprise ent, activite activ wher= e activ.numactivite =3D $activite order by ent.effectif"; Do you know this problem and how to resolve it. Thanks a lot for a quickly response. Terre =E0 D=E9lices Christophe TOUDIC 8 rue Hermann Frenkel 69007 LYON T=E9l : 04 78 61 46 33 Fax : 04 78 61 46 99 Email : terre@delices.com