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
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 very simple. Only records of node type "Drop-
