Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT FOR UPDATE returns zero rows - Mailing list pgsql-novice

From Dima Pavlov
Subject Re: SELECT FOR UPDATE returns zero rows
Date
Msg-id CAHt_LuuVNWWeXK_ovFzG_F4NN3Wk3-kt968g759TBJZLONfqng@mail.gmail.com
Whole thread Raw
In response to Re: SELECT FOR UPDATE returns zero rows  (amul sul <sulamul@gmail.com>)
Responses Re: SELECT FOR UPDATE returns zero rows
List pgsql-novice
Tree view
1. 1 row. 
    t2c2: 100


2. 1 row. 
_pk:1
t1c1: 123456789
t1c2: 100
t1c3: "string_value_1"

Example:

CREATE TABLE t1 (_pk serial, t1c1 integer, t1c2 integer, t1c3 text);
CREATE TABLE t2 (_pk serial, t2c1 text, t2c2 integer);
insert into t1 (t1c1, t1c2, t1c3) values(123456789, 100, 'string_value_1');
insert into t2 (t2c1, t2c2) values('string_value_2', 100);

On Sun, Sep 18, 2016 at 9:41 AM, amul sul <sulamul@gmail.com> wrote:
What is output of following queries:

1. SELECT t2c2 FROM t2 WHERE t2c1 = "string_value_2"
2. SELECT * FROM t1 WHERE t1c1 = 123456789 AND t1c2 IN (SELECT t2c2
FROM t2 WHERE t2c1 = "string_value_2")

Regards,
Amul

pgsql-novice by date:

Previous
From: "Amit S."
Date:
Subject: Re: :
Next
From: amul sul
Date:
Subject: Re: SELECT FOR UPDATE returns zero rows