On 11/14/05, Tino Wildenhain <[EMAIL PROTECTED]> wrote: > New in 8.1 it seems functions marked STABLE are > not allowed to have any INSERT statement in them. >
this is not new, always was said that SATBLE and IMMUTABLE functions must not modify the database. But beginning with 8.0.0 these kind of thing are checked at compile time. -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend