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

[Rodrigo De León]

On 7/17/07, Norm Garand <[EMAIL PROTECTED]> wrote:

/---------------
 IF $7 IS NOT NULL THEN
  AND f.id = pid.specific_location_cid AND f.long_desc = $7
 END IF
---------------/

How about:

  AND f.ID = pid.specific_location_cid
  AND f.long_desc = COALESCE ($7, f.long_desc)

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend