Postgres Pro
Downloads
Home   >   mailing lists

Re: The same prepared query yield "-1" the first six times and then "-1.0" - Mailing list pgsql-general

From Ron
Subject Re: The same prepared query yield "-1" the first six times and then "-1.0"
Date
Msg-id 5eced581-3b03-2c51-7bf8-946f34bd968e@gmail.com
Whole thread Raw
In response to Re: The same prepared query yield "-1" the first six times and then "-1.0"  (Dave Cramer <davecramer@postgres.rocks>)
Responses Re: The same prepared query yield "-1" the first six times and then "-1.0"  (Dave Cramer <davecramer@postgres.rocks>)
List pgsql-general
Tree view
On 8/21/23 14:32, Dave Cramer wrote:
[snip]
It has to do with the way the data is being transferred. When the driver switches to a named statement it also switches to binary mode which means data will be transferred in binary. 

In text we get -1, in binary we get -1.0

That seems odd.  Why does it do that?

--
Born in Arizona, moved to Babylonia.

pgsql-general by date:

Previous
From: Dave Cramer
Date:
Subject: Re: The same prepared query yield "-1" the first six times and then "-1.0"
Next
From: Dave Cramer
Date:
Subject: Re: The same prepared query yield "-1" the first six times and then "-1.0"