I'm about at my wits end here. Normally to find all the rows with a timestamp (w/o timezone) i use date_trunc but for my current use case i tried extract (example below). It worked perfectly in PGadmin but when I implimented it in c# using Npgsql, suddenly it wouldn't work. the program hung with no output or errors indicating there was a problem. I'm working with large pools of data and need to process them a month at a time so for something like this:

SELECT * FROM (the table) WHERE EXTRACT('month' FROM createdAt) = 10 AND EXTRACT('year' FROM createdAt) = 2023;

to give me everything from October last year is a godsend. Has anybody run into this issue? where the query works in PGadmin but doesn't using Npgsql? I've googled a lot and cant find any similar issue