Returning empty on insert

From: Winanjaya Amijoyo <winanjaya(dot)amijoyo(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Returning empty on insert
Date: 2019-05-16 07:53:57
Message-ID: CAAHo4LNFA7F+PKTqq5dEbWaDzjEe8z=G9K7ky4YWyDxTV04A-A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

when running query below, pid returns empty when inserting new record

WITH s AS (
SELECT pid FROM test WHERE area = 'test5'
), i AS (
INSERT INTO test (area)
SELECT 'test5'
WHERE NOT EXISTS (SELECT 1 FROM s)
RETURNING pid
)
UPDATE area
SET last_update = CURRENT_TIMESTAMP
WHERE pid = (SELECT pid FROM s)
RETURNING pid;

what I missed?

please help

many thanks in advance

Regards

Win

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Winanjaya Amijoyo 2019-05-16 08:26:04 Re: Returning empty on insert
Previous Message Kyotaro HORIGUCHI 2019-05-16 07:12:19 Re: terminating walsender process due to replication timeout