Re: Me again with an insert trigger problem

On 2/27/24 14:38, Thiemo Kellner wrote:
> 
> Am 27.02.2024 um 23:20 schrieb Adrian Klaver:

> 
> I am not sure, what you want me to show with your test case. And I am 
> not sure whether I could not make myself clear. Please bear with me if I 
> try to make things clearer with an example.

Your comment was:

"Coming from Oracle, I missed that using "true" is also possible and 
better because clearer."

Just showing true is available in Postgres also.

> 
> -- bit-harder-to-test-statement
> select count(*)
>    from TRUE_TEST
>   where ID < 100  -- if I want to deactivate that part of the clause, I 
> have to rewrite
>     and mod(ID, 5) = 0;
> 
> -- bit-easier-to-test-statement
> select count(*)
>    from TRUE_TEST
>   where true
>     and ID < 100  -- if I want to deactivate that part of the clause, I 
> just comment it out
>     and mod(ID, 5) = 0
>     and true;
> 
> Cheers
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com