X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 318D7D1EA4C
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  6 May 2004 05:52:40 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 65992-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  6 May 2004 05:52:20 -0300 (ADT)
Received: from minkar.com (unknown [216.121.191.44])
	by svr1.postgresql.org (Postfix) with ESMTP id B9983D1E746
	for <pgsql-sql@postgresql.org>; Thu,  6 May 2004 05:52:17 -0300 (ADT)
Received: from loroadictos.com (164.Red-80-32-12.pooles.rima-tde.net [80.32.12.164])
	(authenticated)
	by minkar.com Dinamail Server with ESMTPœ id i468q4903257
	for <pgsql-sql@postgresql.org>; Thu, 6 May 2004 01:52:08 -0700
Message-ID: <4099FCB4.1090300@loroadictos.com>
Date: Thu, 06 May 2004 10:52:04 +0200
From: Francesc Leveque <webmaster@loroadictos.com>
User-Agent: Mozilla Thunderbird 0.5 (X11/20040208)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Subselect returning 2 columns
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-DinaScanner-Information: DinaScanner.. Filtro anti-Spam * anti-Virus
X-DinaScanner: Libre de Virus
X-DinaScanner-SpamCheck: 
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Amavis-Alert: BAD HEADER Non-encoded 8-bit data (char 9C hex) in message
	header 'Received'
	Received: ... Dinamail Server with ESMTP\234 id i468q490325...
	^
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200405/60
X-Sequence-Number: 17774

Hello,

Is correct to do something like?:

SELECT row1,row2 FROM mytable
WHERE (row1,row3) IN
(SELECT row1 as p1,MAX(row3) as p2 FROM mytable
WHERE row3 <= current_date
GROUP BY row1)

I mean, I don't see documentation about subselects returning more than 
one column, but it seems to work...

Thanks,
Francesc.