Trigger function syntax - Mailing list pgsql-novice

From Nico Callewaert
Subject Trigger function syntax
Date
Msg-id EC1CEB5509FC644FA5C839B7CD513A1935E5E8@serverets.ets-informatics.local
Whole thread Raw
Responses Re: Trigger function syntax  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice

Hi list,

 

I don’t understand the difference between the following syntax  :

 

CREATE FUNCTION "test_check_a_id" () RETURNS opaque AS '

 

And

 

CREATE FUNCTION LAST_UPDATED() RETURNS "trigger" AS $$

 

Especially the difference between opaque and “trigger”.

And the double quotes, seems sometimes used and sometimes not.

Are there any documentation available out there about triggers / functions syntax ?

 

Many thanks in advance !

Nico

 

pgsql-novice by date:

Previous
From: Robert Bernabe
Date:
Subject: Debugging question ...
Next
From: "Josh Tolley"
Date:
Subject: Re: client authentication - password encryption