On Thu Apr 24, 2014 at 09:42:20AM +0200, Mark Lawrence wrote: > In triggers I often want to include information when raising an error. > However, RAISE doesn't accept dynamic/derived arguments which would > otherwise be valid in a SELECT. > > SELECT RAISE(ABORT, 'string1' || 'string2'); > -- Error: near "'string1'": syntax error
I forgot to mention my real use case: using NEW.column / OLD.column values in the exception message. Neither of those work either (syntax error near "."). -- Mark Lawrence _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
