Getting a range of dates for PostgreSQL

Question

I would like to get the entries for a range of dates, using PostgreSQL.

For example...

beginyear       endyear       name
---------       -------       -----
950             1100          jason
1300            1400          andrew

I would like to get all people who lived in 1050. Could someone please help me to write this query.

Answer 1

SELECT * FROM mytable
 WHERE beginyear <= 1050 AND 1050 <= endyear

Answer 2

select name
from yourtable
where 1050 between beginyear and endyear;