swh-func.sql: use LANGUAGE sql wherever possible
3b67e58d1e2d
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, 11:58 AM

Tasks

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

Event Timeline

zack committed rDSTO3b67e58d1e2d: swh-func.sql: use LANGUAGE sql wherever possible (authored by zack).Sep 30 2015, 11:56 AM

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.