Calling Functions in RULEs

From: "Jan B(dot)" <jan(at)monso(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Calling Functions in RULEs
Date: 2005-05-22 09:24:10
Message-ID: 42904FBA.3080500@monso.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

I would like to call multiple PL/pgSQL procedures (i.e. functions
returning void) from INSERT, UPDATE and DELETE RULEs.

Using "SELECT some_procedure();" is a possible way to do that, but it
causes a dummy result table to be delivered to the application invoking
the INSERT/UPDATE/DELETE. When using multiple SELECTs to call multiple
functions inside the RULE, multiple result tables will be delivered to
the application, which is very unhandy and causes trouble especially
when using asynchronous command processing. Though "psql" does only show
the last result table, all dummy result tables have to be fetched by
PGgetResult(), when using asynchronous mode with libpq.

Is there any tidy way to call a void-function inside a RULE without
creating a result table that is passed to the application?
Using a command like "UPDATE dummy_table SET dummy=1 WHERE
some_procedure() NOTNULL;" would work, but that would be very dirty.

Does a command like "PERFORM" (from PG/pgSQL) exist in SQL too, which
discards the (void) result of the function call?

Thanks for helping

Jan Behrens
||

Browse pgsql-sql by date

  From Date Subject
Next Message Timo Roessner 2005-05-22 11:29:10 datatype conversion on postgresql 7.4.1
Previous Message LAMBEAU Bernard 2005-05-22 09:03:19 Re: [despammed] Balance Calculation