Since this code is in a loop, consider using clock_timestamp() instead of
now(). It might not matter in this situation, though.
On 8/21/23 02:07, Anthony Apollis wrote:
*Please review my code and make recommendations where needed. I have this
code: *```
NUMBER OF LOOPS FOR POSTGRESQL ETL:
SELE
On 2023-08-21 09:07:00 +0200, Anthony Apollis wrote:
> Please review my code and make recommendations where needed. I have this code:
> ```
[complicated code snipped]
>
>
> I have re-written this code to make it less complex, still doing what
> it is supposed to do. I want you to review my re-wri
On Mon, Aug 21, 2023 at 3:07 PM Anthony Apollis
wrote:
>
> Please review my code and make recommendations where needed. I have this code:
> ```
> NUMBER OF LOOPS FOR POSTGRESQL ETL:
> SELECT
> CASE
> WHEN (((EXTRACT(DAY FROM
> ((CASE
> WHEN
> (SELECT DISTINCT "CALDAY" FROM “system”.”IMETA_ZACTPRIC
*Please review my code and make recommendations where needed. I have this code:
*```
NUMBER OF LOOPS FOR POSTGRESQL ETL:
SELECT
CASE
WHEN (((EXTRACT(DAY FROM
((CASE
WHEN
(SELECT D