Search Postgresql Archives

Re: Me again with an insert trigger problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 select retrieves the type of the node in order to determine whether a task name must be given or not.

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 possible and better because clearer.

Seems  '... where  ID = new.NODE⠒ID ...' is sufficient.

Right. Semantically sufficient.


Also what do you want to return as NEW?

The unchanged new record. And it works as intended.

Thanks for your help!





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux