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 wa
Am 27.02.2024 um 23:20 schrieb Adrian Klaver:
On 2/27/24 14:11, Thiemo Kellner wrote:
It is a habit of mine to pad conditions in the where clause. This way,
it is easy to comment/uncomment parts of the clause for testing
purposes. Coming from Oracle, I missed that using "true" is also
possib
On 2/27/24 14:11, Thiemo Kellner wrote:
Am 27.02.2024 um 21:42 schrieb Adrian Klaver:
Also not sure what this:
select NODE_TYPE⠒NAME into V⠒NODE_TYPE⠒NAME
from NODE⠒V
where 1 = 1
and ID = new.NODE⠒ID
and 1 = 1;
is supposed to be doin
Am 27.02.2024 um 21:42 schrieb Adrian Klaver:
Also not sure what this:
select NODE_TYPE⠒NAME into V⠒NODE_TYPE⠒NAME
from NODE⠒V
where 1 = 1
and ID = new.NODE⠒ID
and 1 = 1;
is supposed to be doing especially the 1 = 1 tests?
The selec
Thanks.
27.02.2024 19:09:50 Adrian Klaver :
>
> On 2/27/24 9:49 AM, Thiemo Kellner wrote:
>> Hi
>>
>> I am surprised that my before insert trigger function does not insert any
>> rows into NODE_GOOD.
>>
>> I was under the impression that the trigger function would do the insert
>> with the n
On 2/27/24 9:49 AM, Thiemo Kellner wrote:
Hi
I am surprised that my before insert trigger function does not insert
any rows into NODE_GOOD.
I was under the impression that the trigger function would do the
insert with the new and possibly adapted values. In my case, to me at
least, it is v
