How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Why does my application return different data than a direct SQL query?

calendar_today July 8, 2026 person Dharmendra Prajapati domain spring-boot

I’m facing a strange issue, where the same PostgreSQL function returns different results, when executed from my Java application versus pgAdmin. Environment Spring Boot 3.0.6 PostgreSQL 15.3 JPA EntityManager#createNativeQuery() Same PostgreSQL server, database, schema, and user PostgreSQL Function Call SELECT wisun_get_presence_details_json( ‘8C73DAFFFE1693AE’, 1780857000000, 1783484219909 ); Result from pgAdmin [ {“status”:”DISCONNECTED”,”createdAt”:1780857000000}, {“status”:”CONNECTED”,”createdAt”:1781670691000}, {“status”:”DISCONNECTED”,”createdAt”:1781677649000}, {“status”:”CONNECTED”,”cr

open_in_new Read original post