From: Saulo Venâncio <saulo.venancio@gmail.com>
To: pgsql-sql@postgresql.org
Subject: help on select
Date: Wed, 20 Apr 2011 17:10:32 -0300
Message-ID: <BANLkTinpuRYSkCkU7ovGojjAhbgXcLAP=g@mail.gmail.com> (raw)
Hi guys,
I need your help.
I have a table called medidas, in this table i have some ocurrences that has
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âncio*
Control and Automation Eng. Student
*Associate in Business Management*
T +55 4884121486
*E saulo.venancio@gmail.com
*
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: saulo.venancio@gmail.com
Subject: Re: help on select
In-Reply-To: <BANLkTinpuRYSkCkU7ovGojjAhbgXcLAP=g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox