How too select different views using a IF/THEN/ELSE procedure ? - Mailing list pgsql-sql
From | Wilkinson, Jim |
---|---|
Subject | How too select different views using a IF/THEN/ELSE procedure ? |
Date | |
Msg-id | 7CCC5BEF5E72394C963E529B54EB4A642A199E@SD01ITMV12.PROD.NET Whole thread Raw |
List | pgsql-sql |
<p align="LEFT"><span lang="en-ca"><font face="Arial" size="2">Below is a select statement that select incidents by month. I need a function or a method to select differents views that will show the Month columns is</font></span><span lang="en-ca"></span><spanlang="en-ca"> <font face="Arial" size="2">a</font></span><span lang="en-ca"></span><span lang="en-ca"><font face="Arial" size="2">different</font></span><span lang="en-ca"></span><span lang="en-ca"> <font face="Arial"size="2"> order. Say Apr</font></span><span lang="en-ca"></span><span lang="en-ca"> <font face="Arial" size="2">–</font></span><spanlang="en-ca"></span><span lang="en-ca"><font face="Arial" size="2"> Mar for a fiscal year.</font></span><palign="LEFT"><span lang="en-ca"><font face="Arial" size="2">I need to do something like an if/then/elsestatement that selects the correct view to use by a variable check.</font></span><p align="LEFT"><span lang="en-ca"><fontface="Arial" size="2">Any ideas what I can use or do ?</font></span><br /><br /><p align="LEFT"><span lang="en-ca"><fontface="Arial" size="2">select case public.incident.gender_code_id</font></span><p align="LEFT"><span lang="en-ca"> <font face="Arial" size="2">WHEN 31 THEN 'Male'</font></span><p align="LEFT"><span lang="en-ca"> <font face="Arial" size="2">WHEN 32 THEN 'Female'</font></span><p align="LEFT"><span lang="en-ca"> <font face="Arial" size="2">ELSE 'Non-Person'</font></span><p align="LEFT"><span lang="en-ca"> <font face="Arial" size="2">END,</font></span><p align="LEFT"><span lang="en-ca"> <font face="Arial"size="2">count (case extract ( month from public.incident.incident_date )WHEN 01 then 1 Else NULL END) as Jan,</font></span><p align="LEFT"><span lang="en-ca"> <font face="Arial" size="2">count (case extract ( month frompublic.incident.incident_date )WHEN 02 then 1 Else NULL END) as Feb, </font></span><p align="LEFT"><span lang="en-ca"> <font face="Arial" size="2">count (case extract ( month from public.incident.incident_date )WHEN 03 then1 Else NULL END) as Mar, </font></span><p align="LEFT"><span lang="en-ca"> <font face="Arial" size="2">count (caseextract ( month from public.incident.incident_date )WHEN 04 then 1 Else NULL END) as Apr, </font></span><p align="LEFT"><spanlang="en-ca"> <font face="Arial" size="2">count (case extract ( month from public.incident.incident_date)WHEN 05 then 1 Else NULL END) as May, </font></span><p align="LEFT"><span lang="en-ca"> <font face="Arial" size="2">count (case extract ( month from public.incident.incident_date )WHEN 06 then1 Else NULL END) as Jun, </font></span><p align="LEFT"><span lang="en-ca"> <font face="Arial" size="2">count (caseextract ( month from public.incident.incident_date )WHEN 07 then 1 Else NULL END) as Jul, </font></span><p align="LEFT"><spanlang="en-ca"> <font face="Arial" size="2">count (case extract ( month from public.incident.incident_date)WHEN 08 then 1 Else NULL END) as Aug, </font></span><p align="LEFT"><span lang="en-ca"> <font face="Arial" size="2">count (case extract ( month from public.incident.incident_date )WHEN 09 then1 Else NULL END) as Sep, </font></span><p align="LEFT"><span lang="en-ca"> <font face="Arial" size="2">count (caseextract ( month from public.incident.incident_date )WHEN 10 then 1 Else NULL END) as Oct,</font></span><p align="LEFT"><spanlang="en-ca"> <font face="Arial" size="2">count (case extract ( month from public.incident.incident_date)WHEN 11 then 1 Else NULL END) as Nov, </font></span><p align="LEFT"><span lang="en-ca"> <font face="Arial" size="2">count (case extract ( month from public.incident.incident_date )WHEN 12 then1 Else NULL END) as Dec,</font></span><p align="LEFT"><span lang="en-ca"> <font face="Arial" size="2">count (extract( month from public.incident.incident_date )) as Total </font></span><p align="LEFT"><span lang="en-ca"><font face="Arial"size="2">from public.incident</font></span><p align="LEFT"><span lang="en-ca"><font face="Arial" size="2">GROUPBY public.incident.gender_code_id</font></span><span lang="en-ca"></span><span lang="en-ca"></span>