Re: Database/Table Design for Global Country Statistics - Mailing list pgsql-general

Stefan Schwarzer wrote:
> Just for the completeness, I attach the final working SQL query:
>
> SELECT
>   f.year,
>   f.id,
>   c.name,
>   (f.value / p.value) AS per_capita
> FROM
>   fish_catch AS f
> JOIN
>   pop_total AS p
> USING
>    (year, id)
> INNER JOIN
>    countries AS c ON f.id = c.id
> ORDER BY
>    year

Make sure you fully specify the order:
   ORDER BY year, f.id, c.name
It might work by chance a few times, but then return rows in an
unexpected order later.

--
   Richard Huxton
   Archonet Ltd