Needs Function
От | Penchalaiah P. |
---|---|
Тема | Needs Function |
Дата | |
Msg-id | A70AE049E81A6A40879D5DC0AC8C38C908DCF678@venus.infics.com обсуждение исходный текст |
Список | pgsql-sql |
<img class="shape" height="0" src="cid:image001.jpg@01C78CDA.5ABC5680" style="display:none;width:0;height:0" v:shapes="_x0000_Mail"v:src="cid:image001.jpg@01C78CDA.5ABC5680" width="0" /><div class="Section1"><p class="MsoNormal" style="margin-left:37.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy">PLEASEGO TO FOLLOWING QUERY AND REVERT TO ME IF ANY QUERIES</span></font><pclass="MsoNormal" style="margin-left:37.5pt"><font color="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font><pclass="MsoNormal" style="margin-left:37.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy">SELECT* FROM TEMP;</span></font><p class="MsoNormal" style="margin-left:37.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy">DEPTNO EMPNO</span></font><p class="MsoNormal" style="margin-left:37.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy">------ --------------------------------------------------</span></font><pclass="MsoNormal" style="margin-left:37.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 10 B3091,B3092,B3093,B3085</span></font><p class="MsoNormal"style="margin-left:37.5pt"><font color="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 11 3651,6521</span></font><p class="MsoNormal" style="margin-left:37.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 12 H3062</span></font><p class="MsoNormal" style="margin-left:37.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font><pclass="MsoNormal" style="margin-left:75.0pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font><pclass="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font><pclass="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 1 SELECT DEPTNO,SUBSTR(EMPNO,1,5) EMPNO FROM TEMP WHERE DEPTNO=10</span></font><pclass="MsoNormal" style="margin-left:112.5pt"><font color="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 2 UNION</span></font><p class="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 3 SELECT DEPTNO,SUBSTR(EMPNO,7,5) EMPNO FROM TEMP WHERE DEPTNO=10</span></font><pclass="MsoNormal" style="margin-left:112.5pt"><font color="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 4 UNION</span></font><p class="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 5 SELECT DEPTNO,SUBSTR(EMPNO,13,5) EMPNO FROM TEMP WHERE DEPTNO=10</span></font><pclass="MsoNormal" style="margin-left:112.5pt"><font color="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 6 UNION</span></font><p class="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 7 SELECT DEPTNO,SUBSTR(EMPNO,19,5) EMPNO FROM TEMP WHERE DEPTNO=10</span></font><pclass="MsoNormal" style="margin-left:112.5pt"><font color="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 8 UNION</span></font><p class="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 9 SELECT DEPTNO,SUBSTR(EMPNO,1,4) EMPNO FROM TEMP WHERE DEPTNO=11</span></font><pclass="MsoNormal" style="margin-left:112.5pt"><font color="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 10 UNION</span></font><p class="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 11 SELECT DEPTNO,SUBSTR(EMPNO,6,4) EMPNO FROM TEMP WHERE DEPTNO=11</span></font><pclass="MsoNormal" style="margin-left:112.5pt"><font color="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 12 UNION</span></font><p class="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 13*SELECT DEPTNO,EMPNO FROM TEMP WHERE DEPTNO=12</span></font><p class="MsoNormal"style="margin-left:112.5pt"><font color="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy">SQL>/</span></font><p class="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font><pclass="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> DEPTNO EMPNO</span></font><p class="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy">---------- --------------------------------------------------</span></font><pclass="MsoNormal" style="margin-left:112.5pt"><font color="navy"face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 10 B3085</span></font><pclass="MsoNormal" style="margin-left:112.5pt"><font color="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 10 B3091</span></font><p class="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 10 B3092</span></font><p class="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 10 B3093</span></font><p class="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 11 3651</span></font><p class="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 11 6521</span></font><p class="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> 12 H3062</span></font><p class="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font><pclass="MsoNormal" style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy">7rows selected.</span></font><p><font color="#006666" face="Arial"size="2"><span style="font-size:10.0pt; font-family:Arial;color:#006666"> </span></font></div><table><tr><td bgcolor="#ffffff"><font color="#000000">Informationtransmitted by this e-mail is proprietary to Infinite Computer Solutions and / or its Customersand is intended for use only by the individual or the entity to which it is addressed, and may contain informationthat is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipientor it appears that this mail has been forwarded to you without proper authority, you are notified that any use ordissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately atinfo.in@infics.com and delete this email from your records.<br /></font></td></tr></table><table><tr><td bgcolor="#ffffff"><font color="#000000">============================================================================================================================<br /><br/><br /> Disclaimer:<br /><br /> This message and the information contained herein is proprietary and confidential andsubject to the Tech Mahindra policy statement, you may review at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a>externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a>internally within TechMahindra.<br /><br /> ============================================================================================================================<br /></font></td></tr></table><table><tr><tdbgcolor="#ffffff"><font color="#000000">Information transmitted by this e-mail isproprietary to Infinite Computer Solutions and / or its Customers and is intended for use only by the individual or theentity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosureunder applicable law. If you are not the intended recipient or it appears that this mail has been forwarded toyou without proper authority, you are notified that any use or dissemination of this information in any manner is strictlyprohibited. In such cases, please notify us immediately at info.in@infics.com and delete this email from your records.<br/></font></td></tr></table>
В списке pgsql-sql по дате отправления:
Предыдущее
От: Richard Broersma JrДата:
Сообщение: Re: Joe Celko's method to "generate_series" not working?