On Fri, Mar 04, 2022 at 05:03:14PM -0500, Tom Lane wrote:
> hubert depesz lubaczewski writes:
> > On Fri, Mar 04, 2022 at 02:09:52PM -0500, Tom Lane wrote:
> >> I tried and failed to reproduce this on Fedora 35 on aarch64,
> >> but that has what I think is a newer LLVM version:
>
> > I have suspi
hubert depesz lubaczewski writes:
> On Fri, Mar 04, 2022 at 05:03:14PM -0500, Tom Lane wrote:
>> Mmm ... it might have just been that the planner chose not to use
>> JIT when it thought there were fewer rows involved. Did you check
>> with EXPLAIN that these cut-down cases still used JIT?
> I to
Let say that I have a database named stp. I also have another database
named geo that is a PostGIS database for storing geopolitical and
geospatial data. I want to set up a foreign data wrapper in stp to
connect to geo, so that for each address in stp, I only have to store
the primary key value
Hello,
In this example:
```
CREATE TYPE contact AS (
firstname VARCHAR,
lastname VARCHAR
);
postgres=# SELECT json_populate_record(NULL::contact,
postgres(# '{
postgres'# "firstname": "John",
postgres'# "lastname": "Doe"
postgres'#}'
postgres'# );
json_populate_record
=?UTF-8?Q?St=C3=A9phane_Klein?= writes:
> **Question:** do you know a method like json_populate_record (
> https://www.postgresql.org/docs/13/functions-json.html), which allows
> creating a `ROW` with named field notation without using a json format?
You mean you want to give the field names expl
In line below...
On Monday, March 7, 2022, 05:36:34 AM GMT+13, Susan Hurst
wrote:
Let say that I have a database named stp. I also have another database
named geo that is a PostGIS database for storing geopolitical and
geospatial data. I want to set up a foreign data wrapper in stp t
