Re: Limiting with a left outer join

On Sun, Feb 12, 2006 at 08:03:07AM -0800, Bill Moseley wrote:
> BTW -- Is there a way to turn something like this into a view? The
> 2 domain bind parameters will alway match, and the only other
> input parameters are the two review mode booleans. That is, the
> input to the query is a domain id, and if "review_mode" must be false.

The usual way is to create a view that includes the columns you
might want to restrict on, define the view to select all rows, then
query the view with an appropriate WHERE clause. Another possibility
is to create a set-returning function that accepts the relevant
values as arguments and plugs them into the query.

--
Michael Fuhr