Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4275: Multicolumn subquery expression not allowed on both sides of IS DISTINCT FROM - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4275: Multicolumn subquery expression not allowed on both sides of IS DISTINCT FROM
Date
Msg-id 3563.1214922756@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4275: Multicolumn subquery expression not allowed on both sides of IS DISTINCT FROM  ("Carl-Daniel Hailfinger" <c-d.hailfinger.devel.2006@gmx.net>)
Responses Re: BUG #4275: Multicolumn subquery expression not allowed on both sides of IS DISTINCT FROM
List pgsql-bugs
Tree view 
"Carl-Daniel Hailfinger" <c-d.hailfinger.devel.2006@gmx.net> writes:
> This works:
> # SELECT ROW(true,true)=(SELECT true,true);

> This doesn't:
> # SELECT (SELECT true,true)=(SELECT true,true);
> Error:  42601: subquery must return only one column

This is not a bug, since we do not claim support for feature F641.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "x"
Date:
Subject: BUG #4276: Feature request aggregate indexes
Next
From: "x"
Date:
Subject: BUG #4277: Feature request inet type cast numeric values