Needs Function - Mailing list pgsql-sql

PLEASE GO TO FOLLOWING QUERY AND REVERT TO ME IF ANY QUERIES

SELECT * FROM TEMP;

DEPTNO   EMPNO

------          --------------------------------------------------

    10         B3091,B3092,B3093,B3085

    11         3651,6521

    12         H3062

  1  SELECT DEPTNO,SUBSTR(EMPNO,1,5) EMPNO FROM TEMP WHERE DEPTNO=10

  2  UNION

  3  SELECT DEPTNO,SUBSTR(EMPNO,7,5) EMPNO FROM TEMP WHERE DEPTNO=10

  4  UNION

  5   SELECT DEPTNO,SUBSTR(EMPNO,13,5) EMPNO FROM TEMP WHERE DEPTNO=10

  6  UNION

  7  SELECT DEPTNO,SUBSTR(EMPNO,19,5) EMPNO FROM TEMP WHERE DEPTNO=10

  8  UNION

  9  SELECT DEPTNO,SUBSTR(EMPNO,1,4) EMPNO FROM TEMP WHERE DEPTNO=11

 10  UNION

 11  SELECT DEPTNO,SUBSTR(EMPNO,6,4) EMPNO FROM TEMP WHERE DEPTNO=11

 12  UNION

 13* SELECT DEPTNO,EMPNO FROM TEMP WHERE DEPTNO=12

SQL> /

    DEPTNO EMPNO

---------- --------------------------------------------------

        10 B3085

        10 B3091

        10 B3092

        10 B3093

        11 3651

        11 6521

        12 H3062

7 rows selected.