Thread: RETURN NULL in the sample of insert trigger on partitioned table

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/ddl-partitioning.html
Description:

Why in provided samples of "insert" triggers on partitioned table at the end
of the triggers you provide "return NULL" not "return NEW"?

This causes, among other things, problems with the GET DIAGNOSTICS clause
var = ROW_COUNT clause.

On Wed, Jul 11, 2018 at 09:34:59AM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/9.6/static/ddl-partitioning.html
> Description:
> 
> Why in provided samples of "insert" triggers on partitioned table at the end
> of the triggers you provide "return NULL" not "return NEW"?
> 
> This causes, among other things, problems with the GET DIAGNOSTICS clause
> var = ROW_COUNT clause.

Uh, you mean measurement_insert_trigger?  Returning NEW would cause the
row to be inserted into the referenced table.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +