Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id C3BD41337B83
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 20 Apr 2011 17:11:00 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 20794-10 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 20 Apr 2011 20:10:53 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-pw0-f46.google.com (mail-pw0-f46.google.com
	[209.85.160.46])
	by mail.postgresql.org (Postfix) with ESMTP id A67A81337BA8
	for <pgsql-sql@postgresql.org>; Wed, 20 Apr 2011 17:10:52 -0300 (ADT)
Received: by pwi15 with SMTP id 15so566343pwi.19
	for <pgsql-sql@postgresql.org>; Wed, 20 Apr 2011 13:10:52 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:from:date:message-id:subject:to
	:content-type; bh=rftYlTawyWgo9sDtiw2w2QixoNiCryTDvC1wgRV27yQ=;
	b=OHwhlFeUAQrmMUfvyDlIr8wj4YIJR819vR6VusfhLrIJJt6tIobZV1xrIr83ScgCwn
	DQnebKaJ58AfSaBkMeBoE15MXNvOXi86kojxw3inKrtiP++e3n+3nhggLxH0HBRox8EM
	RxICGz7UTAojyC/WVoNzNP5lAqmsdxLJa/YLI=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:from:date:message-id:subject:to:content-type;
	b=R+6I7pzKT1h3UPHx3Ztkre7puA4JjS/mb6r+sbsiVrnwWMkJnGAssLD8jR6N2f7fCl
	HaNJAqhXZiS3elAnvijM3Jht8OIHh1GzmMgXAMJm0Zaih6iisV/mAeuoBfrIaLgZmqyg
	e4TU0ohambdRRTEkXzR3B+QF0gfEX1UCwVqeQ=
Received: by 10.68.47.131 with SMTP id d3mr11538603pbn.147.1303330252058; Wed,
	20 Apr 2011 13:10:52 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.68.65.166 with HTTP; Wed, 20 Apr 2011 13:10:32 -0700 (PDT)
From: =?ISO-8859-1?Q?Saulo_Ven=E2ncio?= <saulo.venancio@gmail.com>
Date: Wed, 20 Apr 2011 17:10:32 -0300
Message-ID: <BANLkTinpuRYSkCkU7ovGojjAhbgXcLAP=g@mail.gmail.com>
Subject: help on select
To: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=bcaec52e65e9b2f22304a15f3840
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.887 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RFC_ABUSE_POST=0.001,
	T_TO_NO_BRKTS_FREEMAIL=0.01
X-Spam-Level: 
X-Archive-Number: 201104/32
X-Sequence-Number: 35279

--bcaec52e65e9b2f22304a15f3840
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi guys,
I need your help.
I have a table called medidas, in this table i have some ocurrences that ha=
s
id_medida(primary key) id_ponto (sec_key) and also datetime field as
timestamp.
i would like to know from a set of idpontos, e.g. 10,11,23,24.... how can i
get the most recent date that is common to all??
for example, if idponto das date 2011-02-03 but none of others have this
date in the db i dont want this. i want one common for all..
thanks.

*-----------------------
**Saulo B. M. Ven=E2ncio*

Control and Automation Eng. Student
*Associate in Business Management*

T +55 4884121486
*E saulo.venancio@gmail.com
*

--bcaec52e65e9b2f22304a15f3840
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi guys,=A0<div>I need your help.</div><div>I have a table called medidas, =
in this table i have some ocurrences that has id_medida(primary key) id_pon=
to (sec_key) and also datetime field as timestamp.</div><div>i would like t=
o know from a set of idpontos, e.g. 10,11,23,24.... how can i get the most =
recent date that is common to all??</div>

<div>for example, if idponto das date 2011-02-03 but none of others have th=
is date in the db i dont want this. i want one common for all..</div><div>t=
hanks.<br clear=3D"all"><div><font face=3D"tahoma,sans-serif"><p style=3D"c=
olor:rgb(0, 0, 0)">

<b><span lang=3D"EN-US" style=3D"font-size:8.0pt;color:navy"><b><span lang=
=3D"EN-US" style=3D"font-size:8.0pt;color:navy">-----------------------<br>=
</span></b></span></b><b><span lang=3D"EN-US" style=3D"font-size:8.0pt;colo=
r:navy"><b><span lang=3D"EN-US" style=3D"font-size:8.0pt;color:navy">Saulo =
B. M. Ven=E2ncio</span></b></span></b></p>

<p style=3D"color:rgb(0, 0, 0)"><span lang=3D"EN-US" style=3D"font-size:8.0=
pt;color:gray">Control and Automation Eng. Student<br></span><b><span lang=
=3D"EN-US" style=3D"font-size:8.0pt"><span style=3D"color:gray;font-weight:=
normal">Associate in Business Management</span></span></b></p>

<p><span style=3D"font-size:10.8333px;color:rgb(0, 0, 0)"><span style=3D"co=
lor:gray">T
  </span><span style=3D"color:gray">+55 4884121486<br></span></span><b><spa=
n style=3D"font-weight:normal;color:rgb(0, 0, 0)"><span style=3D"color:gray=
">E
  </span></span><span style=3D"font-weight:normal"><a href=3D"mailto:saulo.=
venancio@gmail.com" style=3D"color:navy;font-size:8pt" target=3D"_blank">sa=
ulo.venancio@gmail.com</a><br></span></b><font color=3D"#000080"><span styl=
e=3D"font-size:11px"><br>

</span></font></p><p style=3D"color:rgb(0, 0, 0)"><span style=3D"font-size:=
8.0pt;color:gray"></span></p></font></div><br>
</div>

--bcaec52e65e9b2f22304a15f3840--