Re: [SQL] SQL function triggers

2002-10-15 Thread Jan Wieck
Brian Blaha wrote: > > I would like to write a function as a set of SQL statements, and then > use that function > in a trigger. However, since triggers require a return type of opaque, > and SQL functions > cannot return type opaque, this doesn't look possible. Am I missing > something? The SQL

Re: [SQL] SQL function triggers

2002-10-15 Thread Tom Lane
Brian Blaha <[EMAIL PROTECTED]> writes: > I would like to write a function as a set of SQL statements, and then > use that function > in a trigger. However, since triggers require a return type of opaque, > and SQL functions > cannot return type opaque, this doesn't look possible. You could cal

[SQL] SQL function triggers

2002-10-14 Thread Brian Blaha
I would like to write a function as a set of SQL statements, and then use that function in a trigger. However, since triggers require a return type of opaque, and SQL functions cannot return type opaque, this doesn't look possible. Am I missing something? The SQL that I would expect to do this