Postgres Pro
Downloads
Home   >   mailing lists

Returning empty on insert - Mailing list pgsql-general

From Winanjaya Amijoyo
Subject Returning empty on insert
Date
Msg-id CAAHo4LNFA7F+PKTqq5dEbWaDzjEe8z=G9K7ky4YWyDxTV04A-A@mail.gmail.com
Whole thread Raw
Responses Re: Returning empty on insert
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: terminating walsender process due to replication timeout
Next
From: David Rowley
Date:
Subject: Re: Returning empty on insert