Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5F6A12E09A2 for ; Sun, 23 Dec 2007 12:37:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 04764-07 for ; Sun, 23 Dec 2007 12:37:50 -0400 (AST) Received: from sargon.lncsa.com (sargon.lncsa.com [212.99.8.251]) by postgresql.org (Postfix) with ESMTP id 7114A2E08B5 for ; Sun, 23 Dec 2007 12:37:49 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by sargon.lncsa.com (Postfix) with ESMTP id 61814302790F for ; Sun, 23 Dec 2007 17:37:47 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at lncsa.com Received: from sargon.lncsa.com ([127.0.0.1]) by localhost (sargon.lncsa.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id KW7uc5L09lKe for ; Sun, 23 Dec 2007 17:37:47 +0100 (CET) Received: from zenon.apartia.fr (zenon.apartia.fr [10.0.3.1]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "zenon.apartia.fr", Issuer "ca.apartia.fr" (verified OK)) by sargon.lncsa.com (Postfix) with ESMTP id 43ABC300643A for ; Sun, 23 Dec 2007 17:37:47 +0100 (CET) Received: from timgad.apartia.fr (AToulouse-256-1-15-214.w90-38.abo.wanadoo.fr [90.38.98.214]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "timgad.apartia.fr", Issuer "ca.apartia.fr" (verified OK)) by zenon.apartia.fr (Postfix) with ESMTP id 78CE159C5B428 for ; Sun, 23 Dec 2007 17:37:46 +0100 (CET) Received: by timgad.apartia.fr (Postfix, from userid 1000) id 5358E2C0744B2; Sun, 23 Dec 2007 17:37:45 +0100 (CET) Date: Sun, 23 Dec 2007 17:37:45 +0100 From: Louis-David Mitterrand To: pgsql-sql@postgresql.org Subject: Re: passing a multiple join to a function? Message-ID: <20071223163745.GA6472@apartia.fr> Mail-Followup-To: pgsql-sql@postgresql.org References: <20071217130629.GA8338@apartia.fr> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/118 X-Sequence-Number: 29810 On Mon, Dec 17, 2007 at 12:27:34PM -0500, Rodrigo De León wrote: > On 12/17/07, Louis-David Mitterrand wrote: > > I've got this ugly case statement that I'd like to hide in a function: > > Why don't you hide the entire query in a VIEW? That is probably the best solution. Thanks