On Thu, Jun 2, 2022 at 12:05 PM Garfield Lewis
wrote:
> > Binary representations are not too well documented :-(. However,
> > looking at record_send() helps here.
>
> will have a look…
>
>
> > Right, with the additional proviso that -1 "length" indicates a null
> > field value.
>
> Thx, Tom… ne
On Thu, Jun 2, 2022 at 12:32 AM Tom Lane wrote:
> Jeff Janes writes:
> > On Tue, May 31, 2022 at 4:04 PM Tim Kelly
> wrote:
> >> I do not see evidence that the nested loop is trying to reduce overhead
> >> by using the smaller set. It seems to want to scan on data first either
> >> way.
>
> >
> Binary representations are not too well documented :-(. However,
> looking at record_send() helps here.
will have a look…
> Right, with the additional proviso that -1 "length" indicates a null
> field value.
Thx, Tom… never thought the null field…
--
Regards,
Garfield A. Lewis
Garfield Lewis writes:
> In my client-side C code I am using PQgetvalue to pull in the data from the
> row/column. However, since it is a composite type, it is unclear to me how to
> get the individual members from the data.
Binary representations are not too well documented :-(. However,
look
Hi All,
I’m not sure if this is the actual place for this but I guess I can start here.
The question I have is, I’ve created a composite type like this:
CREATE TYPE myxml AS { encoding_ int4, xml_ xml };
In my client-side C code I am using PQgetvalue to pull in the data from the
row/column. Ho
Hey bruce, thanks for the prompt reply !
It reproduces in 12.11 and 13.7, we use a managed offering that is yet to
include pg 14,
so sadly I can't try expressional extended statistics as of yet, nor can I
attach gdb to the process
to debug the flow.
If any other directions come to mind, I'd reall
On Thu, 2022-06-02 at 12:45 +0530, jian he wrote:
> Trying to display some special Chinese characters in Postgresql.
>
> localhost:5433 admin@test=# show LC_COLLATE;
> ++
> | lc_collate |
> ++
> | C.UTF-8 |
> ++
>
> > with strings(s) as (
> > values (U&'\+
Inspired by this thread:
https://www.postgresql.org/message-id/011f01d8757e%24f5d69700%24e183c500%24%40ndensan.co.jp
Trying to display some special Chinese characters in Postgresql. For now I
am using postgresql 15 beta1. The OS is Ubuntu 20.
localhost:5433 admin@test=# show LC_COLLATE;
+-