On 11/26/21 12:10, Alvaro Herrera wrote:
On 2021-Nov-26, Adrian Klaver wrote:
On 11/26/21 11:44, Alvaro Herrera wrote:
On 2021-Nov-26, Shaozhong SHI wrote:
I am using the MERGE patch I posted here[1], on top of Postgres 15.
https://postgr.es/m/20252245.byerxxac444d@alvherre.pgsql
A pat
On 2021-Nov-26, Adrian Klaver wrote:
> On 11/26/21 11:44, Alvaro Herrera wrote:
> > On 2021-Nov-26, Shaozhong SHI wrote:
> >
> > I am using the MERGE patch I posted here[1], on top of Postgres 15.
> >
> > https://postgr.es/m/20252245.byerxxac444d@alvherre.pgsql
>
> A patch that as AFAIK is
On 11/26/21 11:44, Alvaro Herrera wrote:
On 2021-Nov-26, Shaozhong SHI wrote:
I am using the MERGE patch I posted here[1], on top of Postgres 15.
https://postgr.es/m/20252245.byerxxac444d@alvherre.pgsql
A patch that as AFAIK is not even committed to what is at best an alpha
version
On 2021-Nov-26, Shaozhong SHI wrote:
> MERGE INTO Stock USING Buy ON Stock.item_id = Buy.item_id
> WHEN MATCHED THEN UPDATE SET balance = balance + Buy.volume
> WHEN NOT MATCHED THEN INSERT VALUES (Buy.item_id, Buy.volume);
It does work for me:
55479 15devel 680346=# MERGE INTO Stock USING Buy
Chris Cawley writes:
> Here's the query :
> | SELECT pid, age(clock_timestamp(), query_start), usename, query |
> | | FROM pg_stat_activity |
> | | WHERE query != '' AND query NOT ILIKE '%pg_stat_activity%' |
> | | ORDER BY query_start desc; |
> Return output is pid | 4 days | user | ROLLB
On 11/26/21 1:08 PM, Shaozhong SHI wrote:
CREATE TABLE Stock(item_id int UNIQUE, balance int);
INSERT INTO Stock VALUES (10, 2200);
INSERT INTO Stock VALUES (20, 1900);CREATE TABLE Buy(item_id int, volume int);
INSERT INTO Buy values(10, 1000);
INSERT INTO Buy values(30, 300);
MERGE INTO Stock
As evidenced by the lack of such a command in our documentation this
doesn't exist. We do offer similar functionality directly as part of the
INSERT command via its ON CONFLICT clause.
David J.
CREATE TABLE Stock(item_id int UNIQUE, balance int);
INSERT INTO Stock VALUES (10, 2200);
INSERT INTO Stock VALUES (20, 1900);
CREATE TABLE Buy(item_id int, volume int);
INSERT INTO Buy values(10, 1000);
INSERT INTO Buy values(30, 300);
MERGE INTO Stock USING Buy ON Stock.item_id = Buy.item_id
Excellent idea David, silly me, I didn't think of that. For the other questions:
>How many partitions?
14
>How many rows do they have when performance is slowing considerably?
Not sure, maybe on the low millions
>Does this table get many updates or is it insert only?
insert
>What version of Post
Jakub Jedelsky writes:
> during our tests of Postgres with ICU we found an issue with ILIKE of upper
> and lowercase sigma (Σ). The letter has two lowercase variants σ and ς (at
> the end of a word). I'm working with en_US and en-US-x-icu collations and
> results are a bit unexpected - they are in
Hi,
on the postgres repo, on centos 7 x86, I can found the old postgres 9.5,
and a postgis 2.4
I need to found a postgres 9.5 with a postgis 2.5.1
where can I found it ?
(I know... its obsolete...)
thanks
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
On 26/11/21 9:37 π.μ., Jakub Jedelsky wrote:
Hello,
Thank you for dealing with Greek!
during our tests of Postgres with ICU we found an issue with ILIKE of upper and lowercase sigma (Σ). The letter has two lowercase variants σ and ς (at the end of a word). I'm working with en_US and
en-US-x-i
12 matches
Mail list logo
