pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: The same prepared query yield "-1" the first six times and then "-1.0"
Date: Mon, 21 Aug 2023 15:00:31 -0500
Message-ID: <5eced581-3b03-2c51-7bf8-946f34bd968e@gmail.com> (raw)
In-Reply-To: <CADK3HHLxWKvc_jJQhcMs0MgQhyHEW4479m=YRFuz-6vUZKNYLw@mail.gmail.com>
References: <5C40B9CC-40E4-4AC5-95A1-E5A521C282EF@gmail.com>
	<4e6d74b2-8beb-079d-4db1-f729fa76b7c2@aklaver.com>
	<7C9C6D48-804A-44F7-836B-8B8AEE6D60CA@gmail.com>
	<CADK3HHLxWKvc_jJQhcMs0MgQhyHEW4479m=YRFuz-6vUZKNYLw@mail.gmail.com>

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.

view thread (19+ messages)  latest in thread

Message-ID: <5eced581-3b03-2c51-7bf8-946f34bd968e@gmail.com>
Permalink:  ../5eced581-3b03-2c51-7bf8-946f34bd968e@gmail.com/
Also on:    postgresql.org/message-id/5eced581-3b03-2c51-7bf8-946f34bd968e@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: ronljohnsonjr@gmail.com
  Subject: Re: The same prepared query yield "-1" the first six times and then "-1.0"
  In-Reply-To: <5eced581-3b03-2c51-7bf8-946f34bd968e@gmail.com>
  References: <5C40B9CC-40E4-4AC5-95A1-E5A521C282EF@gmail.com> <4e6d74b2-8beb-079d-4db1-f729fa76b7c2@aklaver.com> <7C9C6D48-804A-44F7-836B-8B8AEE6D60CA@gmail.com> <CADK3HHLxWKvc_jJQhcMs0MgQhyHEW4479m=YRFuz-6vUZKNYLw@mail.gmail.com> <5eced581-3b03-2c51-7bf8-946f34bd968e@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox