swh-func.sql: use LANGUAGE sql wherever possible
25b0544f067d
Actions

Description

swh-func.sql: use LANGUAGE sql wherever possible

Overall, we can use LANGUAGE sql only in 6 cases (vs 17 functions that
remains plpgsql). This is in large part due to the fact that LANGUAGE
sql stored procedures cannot non-existent tables, and most notably
temporary tables.

Closes T55.

Details

Provenance

zack	Authored on
zack	Pushed on Sep 30 2015, 12:33 PM

Tasks

T55: DB stored procedures: use LANGUAGE sql for pure-SQL functions instead of LANGUAGE plpgsql

Event Timeline

zack committed rDSTO25b0544f067d: swh-func.sql: use LANGUAGE sql wherever possible (authored by zack).Sep 30 2015, 12:33 PM

zack added a task: T55: DB stored procedures: use LANGUAGE sql for pure-SQL functions instead of LANGUAGE plpgsql.

Commit No Longer Exists

This commit no longer exists in the repository.