Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- postgres=> CREATE TABLE dane298269( nr_konta VARCHAR(255), pesel VARCHAR(255), P
- RIMARY KEY (nr_konta, pesel), FOREIGN KEY (nr_konta) REFERENCES konta269 (nr_kon
- ta), FOREIGN KEY (pesel) REFERENCES klienci269 (pesel) );
- 1.
- CREATE FUNCTION ilosc_rachunkow269( pesel VARCHAR ) RETURNS BIGINT
- ` AS
- 'SELECT COUNT(nr_konta) FROM dane298269 WHERE pesel = $1 GROUP BY pesel;'
- LANGUAGE SQL;
- postgres=> SELECT DISTINCT ilosc_rachunkow269(pesel), dane298269.pesel FROM dane298269;
- ilosc_rachunkow269 | pesel
- --------------------+-------------
- 1 | 60120490003
- 1 | 80030400002
- 2 | 49020912345
- 3 | 77090300001
- 2.
- CREATE FUNCTION dane_klienta269( pesel VARCHAR ) RETURNS VARCHAR
- AS 'SELECT concat( imie, '' '', nazwisko) FROM klienci269 WHERE pesel
- = $1 GROUP BY pesel;' LANGUAGE SQL;
- 3.
- CREATE FUNCTION format269( nazwisko VARCHAR ) RETURNS VARCHAR as
- 'SELECT upper(nazwisko) FROM klienci269 WHERE nazwisko = $1;' LANGUAGE SQL;
- postgres=> SELECT format269(nazwisko), nazwisko FROM klienci269;
- format269 | nazwisko
- ------------+------------
- NOWAK | Nowak
- MIS | Mis
- NOWAK | Nowak
- SZCZEPANIK | Szczepanik
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement