Range types (int4range, daterange) in PostgreSQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create an integer range from 1 to 10 (excluding 10).

PostgreSQL

SELECT int4range(1, [1]);

Drag options to blanks, or click blank then click option'

A11

B9

C10

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using 11 as upper bound will create a range up to 10 inclusive, which is not the default behavior.

Using 9 will exclude 9 and 10, which is too small.

The int4range function creates a range of integers. The upper bound 10 is excluded by default, so int4range(1, 10) means from 1 up to but not including 10.

2fill in blank

medium

Complete the code to create a date range from January 1, 2023 to January 10, 2023 (excluding the end date).

PostgreSQL

SELECT daterange('2023-01-01', [1]);

Drag options to blanks, or click blank then click option'

A'2023-01-09'

B'2023-01-10'

C'2023-01-11'

D'2023-01-01'

Attempts:

3 left

💡 Hint

Common Mistakes

Using January 9 as end date excludes January 9 itself.

Using January 11 includes January 10, which is beyond the intended range.

The daterange function creates a date range. The end date is exclusive by default, so to include January 9, the end date should be January 10.

3fill in blank

hard

Fix the error in the code to check if the integer 5 is inside the range from 1 to 10.

PostgreSQL

SELECT 5 [1] int4range(1, 10);

Drag options to blanks, or click blank then click option'

A<@

BCONTAINS

C@>

DIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using IN is invalid syntax for range containment.

Using CONTAINS is not a valid SQL operator.

Using @> reverses the operands.

The operator <@ checks if the left value is contained in the right range. So 5 <@ int4range(1, 10) returns true if 5 is inside the range.

4fill in blank

hard

Fill both blanks to create a range from 5 to 15 including 15.

PostgreSQL

SELECT int4range([1], [2], '];');

Drag options to blanks, or click blank then click option'

A5

B15

C16

D14

Attempts:

3 left

💡 Hint

Common Mistakes

Using 15 as upper bound excludes 15 even with '];' bounds.

Using 14 excludes 15.

The int4range function takes lower and upper bounds. The '];' means the range includes the upper bound. To include 15, the upper bound must be 16 because the upper bound is exclusive by default unless specified.

5fill in blank

hard

Fill all three blanks to create a daterange from March 1, 2023 to March 31, 2023 including both dates.

PostgreSQL

SELECT daterange([1], [2], [3]);

Drag options to blanks, or click blank then click option'

A'2023-03-01'

B'2023-04-01'

C'[]'

D'[)'

Attempts:

3 left

💡 Hint

Common Mistakes

Using '()' or '[)' excludes the end date.

Using March 31 as end date excludes March 31.

The daterange function takes start date, end date, and bounds. To include both start and end dates, use bounds '[]'. The end date must be one day after March 31, which is April 1.