Re: [SQL] Most recent row
От
Gary Stainburn
Тема
Re: [SQL] Most recent row
Дата
Msg-id
201705051154.54863.gary.stainburn@ringways.co.uk
Ответ на
Re: [SQL] Most recent row (hubert depesz lubaczewski)
Список
Дерево обсуждения
[SQL] Most recent row Gary Stainburn <gary.stainburn@ringways.co.uk>
Re: [SQL] Most recent row Karsten Hilbert <Karsten.Hilbert@gmx.net>
Re: [SQL] Most recent row Gary Stainburn <gary.stainburn@ringways.co.uk>
Re: [SQL] Most recent row hubert depesz lubaczewski <depesz@depesz.com>
Re: [SQL] Most recent row Gary Stainburn <gary.stainburn@ringways.co.uk>
Re: [SQL] Most recent row hubert depesz lubaczewski <depesz@depesz.com>
Re: [SQL] Most recent row Gary Stainburn <gary.stainburn@ringways.co.uk>
Re: [SQL] Most recent row hubert depesz lubaczewski <depesz@depesz.com>
Re: [SQL] Most recent row Gary Stainburn <gary.stainburn@ringways.co.uk>
Re: [SQL] Most recent row Bob Edwards <bob@cs.anu.edu.au>
Re: [SQL] Most recent row vinny <vinny@xs4all.nl>
Re: [SQL] Most recent row "David G. Johnston" <david.g.johnston@gmail.com>
Re: [SQL] Most recent row Adrian Klaver <adrian.klaver@aklaver.com>
Re: [SQL] Most recent row Michael Moore <michaeljmoore@gmail.com>
Re: [SQL] Most recent row Michael Moore <michaeljmoore@gmail.com>
Re: [SQL] Most recent row Michael Moore <michaeljmoore@gmail.com>
Re: [SQL] Most recent row Thomas Kellerer <spam_eater@gmx.net>
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.
В списке pgsql-sql по дате отправления
