From: | Baux David <david(dot)baux(at)inserm(dot)fr> |
---|---|
To: | jmscott(at)setspace(dot)com |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: |
Date: | 2011-11-15 18:20:23 |
Message-ID: | 4EC2AD67.8080404@inserm.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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 | jmscott | 2011-11-15 18:48:54 | Re: |
Previous Message | jmscott | 2011-11-15 17:29:07 |