How too select different views using a IF/THEN/ELSE procedure ?

Поиск
Список
Период
Сортировка
От Wilkinson, Jim
Тема How too select different views using a IF/THEN/ELSE procedure ?
Дата
Msg-id 7CCC5BEF5E72394C963E529B54EB4A642A199E@SD01ITMV12.PROD.NET
обсуждение исходный текст
Список 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> 

В списке pgsql-sql по дате отправления:

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: union with count?
Следующее
От: Sumeet
Дата:
Сообщение: Track query status