agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Gary Stainburn <gary.stainburn@ringways.co.uk>
To: pgsql-sql@postgresql.org
Subject: Re: Most recent row
Date: Fri, 5 May 2017 11:54:54 +0100
Message-ID: <201705051154.54863.gary.stainburn@ringways.co.uk> (raw)
In-Reply-To: <20170505100037.GA23734@depesz.com>
References: <201705050925.04194.gary.stainburn@ringways.co.uk>
	<201705051044.54259.gary.stainburn@ringways.co.uk>
	<20170505100037.GA23734@depesz.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>

On Friday 05 May 2017 11:00:37 hubert depesz lubaczewski wrote:
> On Fri, May 05, 2017 at 10:44:54AM +0100, Gary Stainburn wrote:
> > > How many rows are in people? How many in assessments? Do you really
> > > want data on all people? Or just some?
> >
> > I was looking for a balanced solution, combining performance and SQL
> > 'purity'.
>
> Solution depends on answers to questions I asked. Will you always get
> data for all people? Or just some? How many assessments per person will
> there usually be?
>
> Best regards,
>
> depesz

Oddly, part of my reply was missing.

As I said, there are currently 720 rows in the people table.  
The will be a new assessment record for each person roughly every six months.
The dataset will be open ended so will slowly but indefinitely grow.

The part that was missing was that there will be new people records added who 
initially will not have an assessment. They will still need to be included in 
the report.



-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

view thread (17+ messages)  latest in thread

Message-ID: <201705051154.54863.gary.stainburn@ringways.co.uk>
Permalink:  ../201705051154.54863.gary.stainburn@ringways.co.uk/
Also on:    postgresql.org/message-id/201705051154.54863.gary.stainburn@ringways.co.uk

reply

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: gary.stainburn@ringways.co.uk
  Subject: Re: Most recent row
  In-Reply-To: <201705051154.54863.gary.stainburn@ringways.co.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox