SQL 过程错误

Question

更改为过程，在“PROCEDURE”处出现语法错误，有什么想法吗？

CREATE PROCEDURE performance_Report
 @startDate DATE,
 @endDate DATE
AS
    SELECT Salesrep.Name, SUM(OrderLine.Quantity) AS Total_Sold, SUM(OrderLine.UnitSellingPrice * Orderline.Quantity) AS Total_Value
    FROM SalesRep, OrderLine, ShopOrder
    WHERE ShopOrder.SalesRepID = SalesRep.SalesRepID
    AND OrderLine.ShopOrderID = ShopOrder.ShopOrderID
    AND ShopOrder.OrderDate BETWEEN @startDate AND endDate
    GROUP BY SalesRep.SalesRepID, SalesRep.Name
    ORDER BY Total_Value DESC;

Answer 1

PostgreSQL 没有“创建过程”。是reported您可能需要在其他数据库中存储过程的大部分内容都可以在 PostgreSQL 中使用 CREATE FUNCTION 完成.