X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 178C7D706A for ; Mon, 22 Aug 2005 12:12:11 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15344-03 for ; Mon, 22 Aug 2005 15:12:06 +0000 (GMT) Received: from mx1.surnet.cl (mx1.surnet.cl [216.155.73.180]) by svr1.postgresql.org (Postfix) with ESMTP id 24F63D6EC0 for ; Mon, 22 Aug 2005 12:12:04 -0300 (ADT) Received: from unknown (HELO cluster.surnet.cl) (216.155.73.164) by mx1.surnet.cl with ESMTP; 22 Aug 2005 11:12:03 -0400 X-IronPort-AV: i="3.96,131,1122868800"; d="scan'208"; a="691223:sNHT14264810928" Received: from alvh.no-ip.org (200.85.218.40) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 42B3EF60008F523A; Mon, 22 Aug 2005 11:11:56 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id EF630C2DC2A; Mon, 22 Aug 2005 11:12:54 -0400 (CLT) Date: Mon, 22 Aug 2005 11:12:54 -0400 From: Alvaro Herrera To: Roger Tannous Cc: "D'Arcy J.M. Cain" , pgsql-sql@postgresql.org, tgl@sss.pgh.pa.us, roger77_lb@hotmail.com Subject: Re: A Table's Primary Key Listing Message-ID: <20050822151254.GD30337@surnet.cl> Mail-Followup-To: Roger Tannous , "D'Arcy J.M. Cain" , pgsql-sql@postgresql.org, tgl@sss.pgh.pa.us, roger77_lb@hotmail.com References: <20050818135524.74852123.darcy@druid.net> <20050822102329.75393.qmail@web51901.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20050822102329.75393.qmail@web51901.mail.yahoo.com> User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.929 required=5 tests=[AWL=-0.847, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, RCVD_IN_NJABL_PROXY=1.026] X-Spam-Level: * X-Archive-Number: 200508/186 X-Sequence-Number: 22414 On Mon, Aug 22, 2005 at 03:23:29AM -0700, Roger Tannous wrote: > So, D'Arcy's solution, although described as 'unsatisfactory' (ref.: > D'Arcy's message), seem to be the only solution. > > So I noticed I was trying to play the wise man, trying to do things in a > better way, but nothing was found than D'Arcy's query: There's a PL/pgSQL function, which was posted to the spanish list: http://archives.postgresql.org/pgsql-es-ayuda/2005-08/msg00644.php Not sure if it qualifies as "better" or "worse" for you. -- Alvaro Herrera () "El que vive para el futuro es un iluso, y el que vive para el pasado, un imbécil" (Luis Adler, "Los tripulantes de la noche")