X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EC2614766EB for ; Thu, 15 May 2003 09:47:45 -0400 (EDT) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with ESMTP id 10105-09 for ; Thu, 15 May 2003 09:47:44 -0400 (EDT) Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by postgresql.org (Postfix) with ESMTP id EB7A64766BC for ; Thu, 15 May 2003 09:47:43 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id 2957DFD0F for ; Thu, 15 May 2003 10:48:38 -0300 (GMT) Received: from bugs (bugs [168.96.132.208]) by bugs.unl.edu.ar (Postfix) with ESMTP id 84DDDFB89 for ; Thu, 15 May 2003 10:48:24 -0300 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: Martin Marques To: pgsql-sql@postgresql.org Subject: comparing 2 queries Date: Thu, 15 May 2003 10:48:20 -0300 X-Mailer: KMail [version 1.4] MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200305151048.20609.martin@bugs.unl.edu.ar> X-Virus-Scanned: by AMaViS snapshot-20020300 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/314 X-Sequence-Number: 13479 I have to queries that return INT values, and I want to know if one is less or equal to the other. Is it posible to put it all in one query and have a return of 1 or 0? I tried somethings with CASE, but it didn't work. -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? ----------------------------------------------------------------- Martín Marqués | mmarques@unl.edu.ar Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------