mernis=# SELECT * FROM citizen WHERE last = 'ERDOGAN' AND \ first = 'RECEP TAYYIP' AND \ date_of_birth LIKE '%/%/1954'; -[ RECORD 1 ]------------+------------------------- uid | 33693950 national_identifier | 17291716060 first | RECEP TAYYIP last | ERDOGAN mother_first | TENZILE father_first | AHMET gender | E birth_city | ISTANBUL date_of_birth | 26/2/1954 id_registration_city | RIZE id_registration_district | GUNEYSU address_city | ANKARA address_district | KECIOREN address_neighborhood | KAVACIK SUBAYEVLERI MAH. street_address | KUSADASI SOKAK door_or_entrance_number | 26 misc |
mernis=# SELECT * FROM citizen WHERE last = 'DAVUTOGLU' AND \ first = 'AHMET' AND \ address_city = 'ISTANBUL' AND \ date_of_birth LIKE '%/1959'; -[ RECORD 1 ]------------+------------------ uid | 12409622 national_identifier | 51541376338 first | AHMET last | DAVUTOGLU mother_first | MEMNUNE father_first | MEHMET DURAN gender | E birth_city | TASKENT date_of_birth | 26/2/1959 id_registration_city | KONYA id_registration_district | TASKENT address_city | ISTANBUL address_district | BAHCELIEVLER address_neighborhood | BAHCELIEVLER MAH. street_address | ISMAILPASA SOKAK door_or_entrance_number | 25 misc |
mernis=# SELECT * FROM citizen WHERE last = 'GUL' AND \ first = 'ABDULLAH' AND \ mother_first = 'ADVIYE'; -[ RECORD 1 ]------------+-------------------- uid | 47612408 national_identifier | 21353291242 first | ABDULLAH last | GUL mother_first | ADVIYE father_first | AHMET HAMDI gender | E birth_city | KAYSERI date_of_birth | 29/10/1950 id_registration_city | KAYSERI id_registration_district | KOCASINAN address_city | ANKARA address_district | CANKAYA address_neighborhood | CANKAYA MAH. street_address | SEHIT ERSAN CADDESI door_or_entrance_number | 3 misc |
