[SQL] A better look at trying to insert a Conditional in a SELECT statement

Hi Again: thanks to those who sent me responses on my first post. I'll try to explain a bit better. There are several parameters that are passed by the user. Each of the parameters that are being passed, may have a NULL value, or an actual numerical value. The parameters filter a large report d

[SQL] Inserting an IF statement in the middle of a SELECT in pl/pgSQL code

Hi: I can't seem to resolve this issue. I have a fair sized SELECT statement that runs properly in a stored procedure using pl/pgSQL, but I have certain parts of the query that can filter by a NULL value, or a character string. What I can't seem to do is insert a conditional IF statement in my c