Submitted by: Alastair Breingan (alb)

Is related to QA633

Votes: 10

It would seem logical and fairly simple (isn't it always when you are not doing the work?) to allow a PSQL procedure to be defined as a SQL or PSQL function. This would simplify the syntax when incorporating these into select statements etc.
For example it is already possible to
select a.*, (select * from GrossProfit(Item)) from ItemMaster
or
select * from ItemMaster where (select * from GrossProfit(Item)) > 30
This proposal would allow the following code without having to write UDF's, which I prefer to restrict to complex computationally intensive code that does not reference the database.
select a.*, GrossProfit(Item) from ItemMaster
or
select * from ItemMaster where GrossProfit(Item) > 30
While the difference is initially not great, I find that these functions are very useful and rapidly become a major part of a business system, at which point the code looks very unwieldy.