Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IDENTITAS
- (
- NIK INTEGER UNIQUE PRIMARY KEY,
- Nama VARCHAR(60) NOT NULL,
- Tanggal_lahir DATE NOT NULL,
- Tempat_lahir VARCHAR(20) NOT NULL,
- Alamat VARCHAR(200) NOT NULL
- );
- ------------------------------------------------------------------------------------
- INSERT INTO IDENTITAS(NIK, Nama, Tanggal_lahir, Tempat_lahir, Alamat)
- VALUES(268791837, 'Muhammad Dzaky Bahrul Ilmi', 'London', 2000-01-17, 'Bandung');
- INSERT INTO IDENTITAS(NIK, Nama, Tanggal_lahir, Tempat_lahir, Alamat)
- VALUES(264872862, 'Muhammad Rafi Bahrur Rizki', 'London', 1990-05-17, 'Bandung');
- ------------------------------------------------------------------------------------
- CREATE OR REPLACE FUNCTION get_Identitas(Name VARCHAR)
- RETURNS TABLE (
- NIK INTEGER,
- Nama VARCHAR
- )
- AS $$
- BEGIN
- RETURN QUERY
- SELECT
- IDENTITAS.NIK,
- IDENTITAS.Nama
- FROM
- IDENTITAS
- WHERE
- Alamat = Name;
- END; $$
- Language plpgsql;
- ------------------------------------------------------------------------------------
- SELECT * FROM get_Identitas('Bandung');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement