From: | jmscott(at)setspace(dot)com |
---|---|
To: | "Baux David" <david(dot)baux(at)inserm(dot)fr> |
Cc: | jmscott(at)setspace(dot)com, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: |
Date: | 2011-11-15 18:48:54 |
Message-ID: | 1d908caf9aaf6e390ee75723e9a73a0c.squirrel@panoz.setspace.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
here is a trivial example in 9.1
jmscott=> select (1, 2) in (select 1, 2);
?column?
----------
t
(1 row)
where the right hand side returns 2 columns, not exactly one column,
contradicting what the docs say:
>> The right-hand side is a parenthesized subquery, which must return
>> exactly one column.
seems like a documentation error. what am i missing?
-j
> well, it seems to me that section 9.20.2 makes sense.
> http://www.w3schools.com/sql/sql_in.asp
> I am not sure that you can compare multiple columns such as in:
>
> SELECT * FROM Persons WHERE LastName, FirstName IN (SELECT LastName,
> FirstName FROM OtherPersons);
>
> if this is what you mean, at least not using this method, which returns
> an error.
>
> d
>
> Le 15/11/11 18:29, jmscott(at)setspace(dot)com a écrit :
>> I would like clarification on the first paragraph of section 9.20.2 on
>> the page at
>>
>> http://www.postgresql.org/docs/9.1/static/functions-subquery.html
>>
>> regarding the syntax of the 'expression in (subquery)' clause.
>>
>> What is meant by
>>
>> The right-hand side is a parenthesized subquery, which must return
>> exactly one column.
>>
>> ? Appears to me that the subquery must only contain the same number of
>> columns as the left hand side, not just 1 column.
>>
>> thanks-j
>>
>>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Baux David | 2011-11-16 09:04:30 | Re: |
Previous Message | Baux David | 2011-11-15 18:20:23 | Re: |