Hello,
2011/5/6 F. BROUARD / SQLpro :
>
> Hi there
>
> I am trying to get an example of SET BASED trigger logic with FOR EACH
> STATEMENT, but I cannot find any example involving the pseudo table NEW
> (or OLD) in the trigger function SQL statement.
>
PostgreSQL doesn't support NEW or OLD tables
Hi there
I am trying to get an example of SET BASED trigger logic with FOR EACH
STATEMENT, but I cannot find any example involving the pseudo table NEW
(or OLD) in the trigger function SQL statement.
Let me give you a real life example.
Suppose we have the above table :
CREATE TABLE T_PRODUIT
I'll give it another try. :)
Is there provision for creating none numeric exclusion constraints on
GIST indexes?
>From my reading of the following, ti doesn't appear to be possible:
http://www.postgresql.org/docs/9.1/static/sql-createtable.html#SQL-CREATETABLE-EXCLUDE
http://www.postgresql.org/d