d33pu
03/21/2022, 2:27 AMcreate or replace function latestOilFee()
return array
IS
Begin
select * from oil_tracker order by ts desc fetch first 1 row only;
End;
Error: syntax error at or near "return"Scott P
03/21/2022, 2:45 AMsql
CREATE OR REPLACE FUNCTION latestOilFee()
RETURNS SETOF oil_tracker
AS $BODY$
BEGIN
RETURN QUERY
SELECT *
FROM oil_tracker
ORDER BY ts DESC
LIMIT 1;
END;
$BODY$ LANGUAGE plpgsql
d33pu
03/21/2022, 2:49 AMd33pu
03/21/2022, 2:49 AM