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;
+-
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&'\+
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
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
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
> 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
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.
>
> >
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
