Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. availability_list(facilityId => integer, startDate => timestamp without time zone, endDate => timestamp without time zone) does not exist"
  2.  
  3. var func = "public.availability_list";
  4.  
  5. var result = db.Query<ReportResponse>(
  6. sql: func,
  7. param: new { facilityId = request.FacilityId, startDate =
  8. DateTime.Now, endDate = DateTime.Now },
  9. commandType: CommandType.StoredProcedure,
  10. commandTimeout: 900) as List<ReportResponse>;
  11.  
  12. CREATE FUNCTION Availability_List(facilityId int, startDate date, endDate date)
  13. RETURNS report_type[]
  14. AS
  15. $$
  16.  
  17. DECLARE
  18. result_record report_type[];
  19.  
  20. BEGIN
  21.  
  22. result_record := array(
  23. SELECT...
  24. );
  25.  
  26. RETURN result_record;
  27.  
  28. END $$ LANGUAGE plpgsql;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement