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 1sTkgM-0023tk-5S for pgsql-general@arkaria.postgresql.org; Tue, 16 Jul 2024 16:05:38 +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 1sTkgK-002G74-SA for pgsql-general@arkaria.postgresql.org; Tue, 16 Jul 2024 16:05:36 +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 1sTkgJ-002G6w-Vx for pgsql-general@lists.postgresql.org; Tue, 16 Jul 2024 16:05:36 +0000 Received: from fhigh7-smtp.messagingengine.com ([103.168.172.158]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sTkgH-002MmK-CL for pgsql-general@postgresql.org; Tue, 16 Jul 2024 16:05:34 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailfhigh.nyi.internal (Postfix) with ESMTP id 716181148095; Tue, 16 Jul 2024 12:05:32 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Tue, 16 Jul 2024 12:05:32 -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=1721145932; x=1721232332; bh=7C/1F5E+0sN9PdnsT79M83L4YmME6uiIPHP6Hdnooxc=; b= Q8/e8NTv9LQZYZYivLxGYZ77wyLz9vJkowbBxvRhm3kQPGLbUrMSAamg+mv2vjA7 MSJfCbZuaigJDCOWNu4q46MVMO1NXTf+sbtrwdbHnjYfDWwfzgeCL24c8p6BE9Co RDOe3QyvrANIygJC/KVWZSPQxbJ7X21njHwCIiJf4e711vwMpmFrFckbhtQP5bEN vR63HOr814oRgTYW+EZuppXxRGo0wVx/ZXgPzhVuuF8DQjto5vOHOqvOHwdzHWFz MfibmhkEwfuIszR5ZeesLjmNa7BwYZxEu5+85IBObW712803sgjKI8iDzvyc5vbE N1+2FtfrRynIuZHiNOkUTA== 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=1721145932; x= 1721232332; bh=7C/1F5E+0sN9PdnsT79M83L4YmME6uiIPHP6Hdnooxc=; b=e I/fYU8Da24qo/soOhxtbU0ths5C1NGzZrovacX3AVyJADsMmGjX+zRMINfUlXQ2R cGUFZqtq2IMrW3vixJkDOjMsiXBiDlZ4Ntgb+mzgikH2Dt67kIr60N8vSUX+6N3W CDpIL1d6NAbQLwho8RCMhXta9jh5TMEKzbBEIl3o0MoLLurLf0QbaUBYXyxszuxk DTfc8MfUvDCFNhuCd80X+W5oxyIInbhwkvHUgcwD7VpeKwefUJbVYW/GLkbqV3Rn WGVTlF7+2RwQxdDd/cFzQiVCYD6aXCcAygBf9DKDD7l8nvN5AZvGDri/7K3MXV+m rDScAKbWH5quxrU3O630Q== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrgeeggdeliecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefkffggfgfuvfevfhfhjggtgfesthejredttddvjeenucfhrhhomheptegurhhi rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh hmqeenucggtffrrghtthgvrhhnpefhveeihfevlefffedthedukeevfefhfedtgeeifeev teffgfefhedtffetudettdenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmh grihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 16 Jul 2024 12:05:29 -0400 (EDT) Message-ID: Date: Tue, 16 Jul 2024 09:05:29 -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> <145933da-bfe0-4755-a99d-e7bde94d7416@aklaver.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 7/16/24 08:57, Anthony Apollis wrote: > That very same code is picking up all the data in the Original Table. > Which only contains past data. It would. select CURRENT_DATE; current_date -------------- 2024-07-16 "Date" < CURRENT_DATE would return data < 2024-07-16. You want data that has dates > 2024-07-16. -- Adrian Klaver adrian.klaver@aklaver.com