Querying with datetime parameter on PostgreSQL dataset

[Rockwell95]

Hello!

I have a question regarding the ability to query for geographic data by its datetime parameter when using PostgreSQL as the data source.

Running queries on sample data with the following query appears to turn up results regardless of their date field in the database:

curl --location 'http://localhost:5000/collections/sensor_sample/items?f=json&limit=10000&sortby=-phenomenon_time&datetime=2024-01-01T00%3A00%3A00.000Z%2F2024-01-24T12%3A30%3A05.000Z'

The code in pygeoapi/pygeoapi/provider/postgresql.py at line 114 (def query(...)) appears to ignore the passed in datetime_ parameter when running a query against the dataset.

I just want to confirm that this is indeed the case, and querying a PostgreSQL dataset by date is not supported. Or perhaps my query is malformed?

Thank you in advance!