Advertisement
rafibatam

Create Table and Function Returns a Table

Jul 31st, 2019
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE IDENTITAS
  2. (
  3. NIK             INTEGER         UNIQUE      PRIMARY KEY,
  4. Nama            VARCHAR(60)     NOT NULL,
  5. Tanggal_lahir   DATE            NOT NULL,
  6. Tempat_lahir    VARCHAR(20)     NOT NULL,
  7. Alamat          VARCHAR(200)    NOT NULL
  8. );
  9.  
  10. ------------------------------------------------------------------------------------
  11. INSERT INTO IDENTITAS(NIK, Nama, Tanggal_lahir, Tempat_lahir, Alamat)
  12. VALUES(268791837, 'Muhammad Dzaky Bahrul Ilmi', 'London', 2000-01-17, 'Bandung');
  13.  
  14. INSERT INTO IDENTITAS(NIK, Nama, Tanggal_lahir, Tempat_lahir, Alamat)
  15. VALUES(264872862, 'Muhammad Rafi Bahrur Rizki', 'London', 1990-05-17, 'Bandung');
  16.  
  17. ------------------------------------------------------------------------------------
  18. CREATE OR REPLACE FUNCTION get_Identitas(Name VARCHAR)
  19. RETURNS TABLE (
  20. NIK     INTEGER,
  21. Nama    VARCHAR
  22. )
  23. AS $$
  24. BEGIN
  25.     RETURN QUERY
  26.     SELECT
  27.         IDENTITAS.NIK,
  28.         IDENTITAS.Nama
  29.     FROM
  30.         IDENTITAS
  31.     WHERE
  32.         Alamat = Name;
  33. END; $$
  34.  
  35. Language plpgsql;
  36.  
  37. ------------------------------------------------------------------------------------
  38. SELECT * FROM get_Identitas('Bandung');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement