On 04/23/2013 12:29 AM, John R Pierce wrote:
On 4/22/2013 3:13 PM, Thomas Kellerer wrote:
Abhinav Dwivedi wrote on 22.04.2013 07:12:
select * from district where statecode in (Select districtcode from
state)
Please note that the attribute districtcode is not existent in the
table state and
i
On 4/22/2013 3:13 PM, Thomas Kellerer wrote:
Abhinav Dwivedi wrote on 22.04.2013 07:12:
select * from district where statecode in (Select districtcode from
state)
Please note that the attribute districtcode is not existent in the
table state and
if this query i.e. Select districtcode from sta
Abhinav Dwivedi wrote on 22.04.2013 07:12:
select * from district where statecode in (Select districtcode from state)
Please note that the attribute districtcode is not existent in the table state
and
if this query i.e. Select districtcode from state is executed in isolation then
it
correctly
On 04/21/2013 10:12 PM, Abhinav Dwivedi wrote:
Dear Member,
We found a bug in postgresql 8.4 details are follows.
If a syntactically wrong query is made inner query of a nested query
then the whole query wrongly returns a dataset instead of an error
message. For example:
select * from distr
