Skip site navigation (1) Skip section navigation (2)

Trigger function syntax

From: "Nico Callewaert" <nico(dot)callewaert(at)ets-informatics(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Trigger function syntax
Date: 2007-11-08 08:48:15
Message-ID: EC1CEB5509FC644FA5C839B7CD513A1935E5E8@serverets.ets-informatics.local (view raw or flat)
Thread:
Lists: 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

 

Responses

pgsql-novice by date

Next:From: Josh TolleyDate: 2007-11-08 14:15:42
Subject: Re: client authentication - password encryption
Previous:From: Robert BernabeDate: 2007-11-08 03:56:38
Subject: Debugging question ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group