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
