Re: [SQL] FOR EACH STATEMENT trigger ?

2011-05-06 Thread Pavel Stehule
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

[SQL] FOR EACH STATEMENT trigger ?

2011-05-06 Thread 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. Let me give you a real life example. Suppose we have the above table : CREATE TABLE T_PRODUIT

[SQL] None numeric exclusion constraints using GIST

2011-05-06 Thread Richard Broersma
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