Ah, just create user-defined functions that take the ID as a parameter and have the user call them, instead of a trigger function, eh? I think I like that better because I can then have separate update and delete functions, with descriptive names. I can do that, and I guess I was looking at this the wrong way. Thanks a million!
On Tue, Jun 4, 2013 at 7:47 AM, David Johnston <pol...@yahoo.com> wrote: > Melvin Call wrote > > But I still have a question in that I'd like to know if I can pass the > > WHERE clause to the function so it can examine the query? Or will I have > > to > > test for the potential of acting on more than one row? > > You can write a function that takes a text/varchar and builds a dynamic SQL > query that then is executed...but I highly advise against it. Basically you > open yourself to SQL injection attack vectors and passing in a where clause > to a function is a very non-intuitive and cumbersome API. > > What you likely want are functions that do what you want and take a person > id as an input. Let the user decide the best way to obtain that person id. > > David J. > > > > > > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/Passing-a-WHERE-clause-by-trigger-to-a-function-tp5757825p5757877.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
