Avoid checks for each row, replace query by function?, PostgreSQL

Language: Layout:

drop table if exists team cascade;
drop table if exists player cascade;

create table team (
    id      integer    primary key,
    type    text
);

create table player
(
    id      integer    primary key,
    age     integer,
    team_id integer    references team(id)
);

insert into team values (1, 'YOUTH');
insert into team values (2, 'ADULT');

-- players for team 1
insert into player values (1, 15, 1);
insert into player values (2, 16, 1);
insert into player values (3, 17, 1);
insert into player values (4, 18, 1);
insert into player values (5, 19, 1);

-- players for team 2
insert into player values (6, 15, 2);
insert into player values (7, 16, 2);
insert into player values (8, 17, 2);
insert into player values (9, 18, 2);
insert into player values (10, 19, 2);

select    player.*
from      player
join      team
on        player.team_id = team.id
where     team.id = 1 and
          (
              (team.type = 'YOUTH' and player.age >= 16) or
              (team.type = 'ADULT' and player.age >= 18)
          );


absolute service time: 0,75 sec