http://www.postgresql.org/docs/8.1/interactive/sql-createtrigger.html
SELECT does not modify any rows so you can not create SELECT triggers.
Rules and views are more appropriate in such cases.
On 4/14/06, A. Kretschmer <[EMAIL PROTECTED]> wrote:
> am 13.04.2006, um 18:46:02 +0300 mailte Sergey Le
Sergey Levchenko <[EMAIL PROTECTED]> schrieb:
> http://www.postgresql.org/docs/8.1/interactive/sql-createtrigger.htmlSELECT
> does not modify any rows so you can not create SELECT triggers.Rules
> and views are more appropriate in such cases. On 4/14/06, A.
Oh yes, i'm sorry.
Andreas
--
Reall
On Thursday 13 April 2006 11:38 pm, "Todd Kennedy" <[EMAIL PROTECTED]>
thus communicated:
--> Hi,
-->
--> I have, what I hope to be, a simple question about plpgsql.
-->
--> I have a trigger on a table right now that updates a count everytime
--> that a new record is entered into a database (or re
On Apr 13 11:38, Todd Kennedy wrote:
> What I'd also like to do is have it create a new row in a different
> table using the automatically assigned id as a reference, but I'm
> unsure of how to obtain the id of the newly created row in the first
> table.
If I understand you right, you're refering
Thank you very much!!!
your suggestion seems really usefull!! I will try it very soon!!!
ivan
Il giorno gio, 13/04/2006 alle 11.34 -0700, Steve Crawford ha scritto:
> > I have a table where there are 20 columns named
> > vinc1, vinc2, vinc3, vinc4, etc
> >
> > the values contained into each
