Re: Code does Not Read in FY 2025 Data
| От | Anthony Apollis |
|---|---|
| Тема | Re: Code does Not Read in FY 2025 Data |
| Дата | |
| Msg-id | CAJyMCY+Q7E7YB=YbxrLyu-B_b+y29RxtrvzR2245+wonEGvcwQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Code does Not Read in FY 2025 Data (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Ответы |
Re: Code does Not Read in FY 2025 Data
|
| Список | pgsql-general |
That very same code is picking up all the data in the Original Table. Which only contains past data.
On Tue, 16 Jul 2024 at 17:39, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
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
В списке pgsql-general по дате отправления: