Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T3Qvg-0004V5-Lr for pgsql-sql@postgresql.org; Mon, 20 Aug 2012 12:18:00 +0000 Received: from hub.ringways.co.uk ([77.86.27.30] helo=mail.ringways.co.uk) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T3Qve-0003pV-6D for pgsql-sql@postgresql.org; Mon, 20 Aug 2012 12:17:59 +0000 Received: from localhost ([127.0.0.1] helo=mail.ringways.co.uk) by mail.ringways.co.uk with esmtp (Exim 4.69) (envelope-from ) id 1T3QvW-0005ZD-0H for pgsql-sql@postgresql.org; Mon, 20 Aug 2012 13:17:51 +0100 Received: from eddie.ringways.co.uk ([10.1.1.115] helo=eddie.ringways.co.uk) by mail.ringways.co.uk with ESMTP id qDHh24BW01023; Mon, 20 Aug 2012 13:17:44 +0100 From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-sql@postgresql.org Subject: generated dates from record dates - suggestions Date: Mon, 20 Aug 2012 13:17:46 +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: <201208201317.46588.gary.stainburn@ringways.co.uk> X-SpamTest-Envelope-From: gary.stainburn@ringways.co.uk X-SpamTest-Info: Profiles 20401 [Mar 31 2011] X-SpamTest-Method: none X-SpamTest-Rate: 0 X-SpamTest-Status: Not detected X-SpamTest-Status-Extended: not_detected X-SpamTest-Version: SMTP-Filter Version 3.0.0 [0285], KAS30/SDK/Release X-Anti-Virus: Kaspersky Mail Gateway, version: 5.6.28/RELEASE, bases: 20110331T110535 #5151353, check: 20120820 clean X-Spam-Score: -51.6 (---------------------------------------------------) X-Spam-Report: Spam detection software, running on the system "ollie.ringways.co.uk", has identified this incoming email as possible spam. The original message has been attached to this so you can view it (if it isn't spam) or label similar future email. If you have any questions, see Gary Stainburn for details. Content preview: Hi folks. I've got a table with three dates which are populated from an external source. I then want to have a view with two calculated dates in it, e.g. if date_1 is null and date_2 is null then date_a=NULL if date_1 is not null and date 2 is null then date_a=date_1+'90 days' if date_1 > date3 rhen date_b=date1 else date_b=date2 etc. [...] Content analysis details: (-51.6 points, 15.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- -50 ALL_TRUSTED Passed through trusted hosts only via SMTP -2.6 BAYES_00 BODY: Bayesian spam probability is 0 to 1% [score: 0.0000] 1.0 RING_SAFE RING_SAFE X-Pg-Spam-Score: -0.2 (/) X-Archive-Number: 201208/20 X-Sequence-Number: 36791 Hi folks. I've got a table with three dates which are populated from an external source. I then want to have a view with two calculated dates in it, e.g. if date_1 is null and date_2 is null then date_a=NULL if date_1 is not null and date 2 is null then date_a=date_1+'90 days' if date_1 > date3 rhen date_b=date1 else date_b=date2 etc. What's the best way to do this? I know it's a quite open question but I'm interested to hear different responses -- Gary Stainburn Group I.T. Manager Ringways Garages http://www.ringways.co.uk