Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sTkGh-001zT9-F1 for pgsql-general@arkaria.postgresql.org; Tue, 16 Jul 2024 15:39:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sTkGg-0020BC-2v for pgsql-general@arkaria.postgresql.org; Tue, 16 Jul 2024 15:39:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sTkGf-0020B2-Ni for pgsql-general@lists.postgresql.org; Tue, 16 Jul 2024 15:39:05 +0000 Received: from fout1-smtp.messagingengine.com ([103.168.172.144]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sTkGd-002MS1-CV for pgsql-general@postgresql.org; Tue, 16 Jul 2024 15:39:04 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailfout.nyi.internal (Postfix) with ESMTP id C9DB51388BA0; Tue, 16 Jul 2024 11:39:02 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Tue, 16 Jul 2024 11:39:02 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1721144342; x=1721230742; bh=qYiaGK09+maRquHjKmXSAW1w7GAiiqVAYIbzaaEtKLM=; b= cogYFWPKT2jth9XJjQz6/Bf8rLVX9iml2N3qtkOm2de6ZoaIQzU5Ox/aGUtIPFps JrEZSYrS33yVrbFQidaigwVgFfQTQ0x5HkTPPB4IX0pXR4F9okfHDukcvMjHRBiI 50Vk+kRqAAb7GODb7Gl6Tw43U3o0lh8YbTWIgoXRiwqDznUreGbCTAqtVUq60Kuq /1K8cZtKfIQbEEmKYItFP+J+TZzFLo0h5D2AQmx7koBbcSM25588Xw9b7Qd9bMjv X2GWlGdzRdEVRKdnL6A0qMZwGLAdbisL1fRRblw7SdMjubMxhtpxnjz0Y3WcY1iU cdqHZs/GITtnf5SfDJDAYw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1721144342; x= 1721230742; bh=qYiaGK09+maRquHjKmXSAW1w7GAiiqVAYIbzaaEtKLM=; b=u vKMh23DV5T54mCDv3fIGwodjph6S+hPWOXdsYNGMjqapEGEzsjWvMQuHxtN/Vb5M 6Xpo2LSIxSyV342VoZuEZVNEkzBFqNdi8iNmuHB8xvBD3NTsZgqeo+iJiLLw954c wHGxHLkPVatGT9mPvRw6keoHGmRRPQnAPhlxXYpEA0OPlJfUG/6w7207zxGqvg8z p0H+f0DSzU+XkcTBwGtqYioLyQisIzXLxrh9wGhHld27BcqFeFJLzPBF59VIwJqB yYeCSgrYzgdWCaQ7T8Xv7IMTLyQtdWACHDpkPEPnBx0auOiwjMIWaiH8FsCSb+IR QVgcY/quRBLZNwq0sBFjw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrgeeggdeklecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefkffggfgfuvfevfhfhjggtgfesthekredttddvjeenucfhrhhomheptegurhhi rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh hmqeenucggtffrrghtthgvrhhnpeefgeefieeutdfggfetgefgheekjeehteeileeigfet ieekjedvieeviefgheevtdenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmh grihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 16 Jul 2024 11:39:01 -0400 (EDT) Message-ID: <145933da-bfe0-4755-a99d-e7bde94d7416@aklaver.com> Date: Tue, 16 Jul 2024 08:39:00 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Code does Not Read in FY 2025 Data To: Anthony Apollis Cc: pgsql-general References: <1fd63ee5-a8a3-492e-a38d-82ff21da26b8@aklaver.com> <82ff4dac-d8b0-4b8b-aa88-e5d74f624a4d@aklaver.com> <5b8cb137-121d-40c6-b907-7d59e53b5e13@aklaver.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 7/16/24 08:28, Anthony Apollis wrote: > Only data up until 2024 is picked up in Revised table, whic contains > 2025 data. THe Maxdate calculation seems to be the problem. This: 'Only data up until 2024 is picked up in Revised table, whic contains 2025 data. .." is consistent with: MaxDate AS ( SELECT MAX("Date") AS "MaxDate" FROM FullWeeks WHERE "Date" < CURRENT_DATE ) I don't see how you expect to fetch data from the future when you limit the data to the past. -- Adrian Klaver adrian.klaver@aklaver.com