Erik, Adrian, The trigger function is very long and complex (and not yet well documented), but bind_action is a normal function callable everywhere, the problem as discovered by Erik was in the null value contained in the hstore.
Anyway, when the ecosystem of functions will work correctly I can share, so you can give me how improve :-D Il giorno mer 5 lug 2023 alle ore 17:33 Erik Wienhold <e...@ewie.name> ha scritto: > > On 05/07/2023 17:16 CEST Adrian Klaver <adrian.kla...@aklaver.com> > wrote: > > > > https://www.postgresql.org/docs/current/plpgsql-trigger.html > > > > 1) > > "A trigger function must return either NULL or a record/row value having > > exactly the structure of the table the trigger was fired for." > > > > 2) I am not seeing where you use: > > > > "TG_ARGV[] > > > > Data type array of text; the arguments from the CREATE TRIGGER > > statement. The index counts from 0. Invalid indexes (less than 0 or > > greater than or equal to tg_nargs) result in a null value." > > > > So I don't see how sqlstr is being set? > > Domenico did not provide the trigger definition, only function bind_action > which he calls from a trigger function. Also bind_action cannot be a > trigger > function because it does not return trigger. > > -- > Erik > -- Domenico L. per stupire mezz'ora basta un libro di storia, io cercai di imparare la Treccani a memoria... [F.d.A.]
