Re: passing a multiple join to a function?

From: Louis-David Mitterrand <vindex+lists-pgsql-sql(at)apartia(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: passing a multiple join to a function?
Date: 2007-12-23 16:37:45
Message-ID: 20071223163745.GA6472@apartia.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Dec 17, 2007 at 12:27:34PM -0500, Rodrigo De León wrote:
> On 12/17/07, Louis-David Mitterrand <vindex+lists-pgsql-sql(at)apartia(dot)org> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Louis-David Mitterrand 2007-12-23 20:55:57 returning an array as a list fo single-column rows?
Previous Message Michael Glaesemann 2007-12-23 00:14:26 Re: Misnamed field in subquery does not cause error when field name exists in parent query