select
	number, street, dem.v_basic_person.lastnames, dem.v_basic_person.preferred, dem.v_basic_person.firstnames, suburb, urb, postcode,
	pk_identity as pk_patient
from
	dem.v_basic_person
		inner join
	dem.v_pat_addresses
		using (pk_identity)
where
	LOWER(dem.v_pat_addresses.postcode) = 'input desired postal code here in lower case'
order by
	street, number
