sql - Pass In "WHERE" parameters to PostgreSQL View? -

Text after "div class =" itemprop = "text">

I have a rather complicated question on spreading 4 tables through a series of my PostgreSQL database nested subqueries. However, despite slightly confused and set-up, eventually it will return two columns (from the same table, if it helps in the case) based on the matching of two external parameters (two strings to match the fields in different tables is required). I am fairly new to designing databases in PostgreSQL, so I know that it appears the magical thing is present in the scene, and this way it seems to help me here, but probably not.

Is there some way I can move my complex query inside a scene and by any means do I need to match it to two values? This can simplify my code on front-end (by changing the complexities into database structure) I can create a scene that wraps my static example query, and it just works well, though it only works with string values Works for a couple of. I should be able to use it with different prices.

So my question is this: Is it possible to pass the parameters in this otherwise static view and has it become "dynamic"? Or maybe one approach is not the right way to approach it. If something else happens that will work better, then I'm all ears!

* Edit: * As requested in the comments, here is my query because it is now standing:

  select Do param_label, param_graphics_label from parameters ou (select param_id from parameter_links where region_id = (regions where region_label = '% parameter 1%' and MODEL_ID = (select model MODEL_ID where model_label = '% region_id selection param_id parameter2 % '))) And activate =' TRUE 'command param_graphics_label;   
 The parameter is closed by the above percent symbols.   
 
 
 You can use a set return function:  
  Or the function returns the label_params (parm1 text, parm2 text) as the $ body, select the table (param_label text, param_graphics_label text) $ ... ou region_label = $ 1 and model_ID = (model model model WHERE Model_label = $ 2) .... $ body $ language sql;   
 Then you can do this:  
  Select label_from ('foo', 'bar')   
 Btw: Do you want to:  
  and MODEL_ID = (Select model MODEL_ID where model_label = $ 2)   
 if  model_label  is not unique (or primary key), it will eventually throw an error. You probably want:  
  and MODEL_ID    < / Html> (Model Where model_label = $ 2 to MODEL_ID)