Postgres Pro
Downloads
Home   >   mailing lists

Re: Two PostgreSQL instances returning different output for same query - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Two PostgreSQL instances returning different output for same query
Date
Msg-id CAKFQuwZzrdpL3SrA34JO_eLrW4tpF5MDPP3KKgtG8jXcC6k6mg@mail.gmail.com
Whole thread Raw
In response to Two PostgreSQL instances returning different output for same query  (John Scalia <jayknowsunix@gmail.com>)
List pgsql-admin
Tree view
On Tue, Aug 30, 2022 at 8:21 AM John Scalia <jayknowsunix@gmail.com> wrote:
The query is a simple:  SELECT to_jsonb(geom) FROM addresses LIMIT 1;


What is the point of LIMIT 1?
David J.

pgsql-admin by date:

Previous
From: John Scalia
Date:
Subject: Two PostgreSQL instances returning different output for same query
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Two PostgreSQL instances returning different output for same query