[SQL] Left Joins...

2001-05-27 Thread Michael Richards
I've got a select that pulls many values from the same table. Basicaly for a given formid there can be many fields each one depending on a definition. So form1 may be broken down as follows: fieldid 1 firstname 2 lasname 3 postal code Rather than sticking this data in

[SQL] Is it possible to defer triggers?

2001-05-27 Thread Torsten Knodt
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, is it possible to defer the execution of a after-trigger? To explain it exactly. I am logging from apache to postgres via insert-commands. I'd like to generate online-statistics in other tables. For this I want to execute a trigger when somet