On 17 February 2012 20:40, Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr> wrote:
> Thom Brown <thom(at)linux(dot)com> writes:
>> And thinking about it, DO is a bit nonsense here, so maybe we'd just
>> have something like:
>> CREATE TRIGGER...
>> AS $$
>> i.e. the same as a function.
> I like that. How do you tell which language the trigger is written in?
Exactly the same as a function I'd imagine. Just tack LANGUAGE
<language>; at the end.
> I'm not so sure about other function properties (SET, COST, ROWS,
> SECURITY DEFINER etc) because applying default and punting users to go
> use the full CREATE FUNCTION syntax would be a practical answer here.
*shrug* There's also the question about the stability of the trigger's
own in-line function too (i.e. IMMUTABLE, STABLE, VOLATILE).
In response to
pgsql-hackers by date
|Next:||From: Andrew Dunstan||Date: 2012-02-17 21:07:31|
|Subject: Re: Triggers with DO functionality|
|Previous:||From: Jay Levitt||Date: 2012-02-17 20:47:35|
|Subject: Re: Designing an extension for feature-space similarity