Re: SELECT FOR UPDATE returns zero rows

From: amul sul <sulamul(at)gmail(dot)com>
To: Dima Pavlov <imyfess(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: SELECT FOR UPDATE returns zero rows
Date: 2016-09-18 04:41:57
Message-ID: CAAJ_b94B4oO4RatKE_no5FeKtP6k4m7pq+XmpVoywg7FDc2bxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message amul sul 2016-09-18 05:47:04 Re: :
Previous Message Levenson, Elliott I. 2016-09-17 22:28:46 :