On Tue, Jul 16, 2024 at 7:59 AM Anthony Apollis <anthony.apollis@xxxxxxxxx> wrote:
I am using Postgres and SQL Server.Can you test the data pls.
Well, this is a PostgreSQL community so you should target it with your communications.
If you want someone to actually test things here you probably will need to produce a psql script that constructs the relevant database objects, populates them, and then executes and produces the empty result you are claiming you see.
In lieu of psql you could use an online fiddle to build this into a self-contained executable form. Here is a link to one.
David J.
