Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1d6YY5-0007aC-2X for pgsql-sql@arkaria.postgresql.org; Fri, 05 May 2017 08:25:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1d6YY4-0006n2-6a for pgsql-sql@arkaria.postgresql.org; Fri, 05 May 2017 08:25:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d6YY3-0006ju-Fq for pgsql-sql@postgresql.org; Fri, 05 May 2017 08:25:11 +0000 Received: from hub.ringways.co.uk ([88.211.105.30] helo=ringways.co.uk) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d6YXz-0007E7-SQ for pgsql-sql@postgresql.org; Fri, 05 May 2017 08:25:10 +0000 Received: from eddie.ringways.co.uk ([10.1.1.115]) by ringways.co.uk with esmtp (Exim 4.89) (envelope-from ) id 1d6YXw-000LJs-DB for pgsql-sql@postgresql.org; Fri, 05 May 2017 09:25:05 +0100 From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-sql@postgresql.org Subject: Most recent row Date: Fri, 5 May 2017 09:25:04 +0100 User-Agent: KMail/1.9.10 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <201705050925.04194.gary.stainburn@ringways.co.uk> X-KLMS-Rule-ID: 1 X-KLMS-Message-Action: clean X-KLMS-AntiSpam-Lua-Profiles: 112276 [May 05 2017] X-KLMS-AntiSpam-Version: 5.7.0.14 X-KLMS-AntiSpam-Envelope-From: gary.stainburn@ringways.co.uk X-KLMS-AntiSpam-Rate: 0 X-KLMS-AntiSpam-Status: not_detected X-KLMS-AntiSpam-Method: none X-KLMS-AntiSpam-Info: LuaCore: 219 219 5c25d3d119ea48db9a5032001f8be732dc5ace77, {msgid_created_by_recepient}, 127.0.0.200:5.2.1;d41d8cd98f00b204e9800998ecf8427e.com:7.1.1;eddie.ringways.co.uk:7.1.1;127.0.0.199:7.1.2,5.2.1;ringways.co.uk:7.1.1 X-KLMS-AntiSpam-Interceptor-Info: scan successful X-KLMS-AntiPhishing: Clean, 2017/05/04 14:05:37 X-KLMS-AntiVirus: Kaspersky Security 8.0 for Linux Mail Server, version 8.0.1.721, bases: 2017/05/05 02:49:00 #9492834 X-KLMS-AntiVirus-Status: Clean, skipped X-Spam-Score: -50.8 (--------------------------------------------------) X-Spam-Report: Spam detection software, running on the system "ollie2.ringways.co.uk", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see Gary Stainburn for details. Content preview: This question has been asked a few times, and Google returns a few different answers, but I am interested people's opinions and suggestions for the *best* wat to retrieve the most recent row from a table. [...] Content analysis details: (-50.8 points, 15.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- -50 ALL_TRUSTED Passed through trusted hosts only via SMTP 0.1 SCORE_RCPTS Adding score for each recipient -0.0 RP_MATCHES_RCVD Envelope sender domain matches handover relay domain -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1% [score: 0.0000] 1.0 RING_SAFE No description available. X-forward-disable: yes X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org This question has been asked a few times, and Google returns a few different answers, but I am interested people's opinions and suggestions for the *best* wat to retrieve the most recent row from a table. My case is: create table people ( p_id serial primary key, ...... ); create table assessments ( p_id int4 not null references people(p_id), as_timestamp timestamp not null, ...... ); select p.*, (most recent) a.* from people p, assessments a .. ; -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql