Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- availability_list(facilityId => integer, startDate => timestamp without time zone, endDate => timestamp without time zone) does not exist"
- var func = "public.availability_list";
- var result = db.Query<ReportResponse>(
- sql: func,
- param: new { facilityId = request.FacilityId, startDate =
- DateTime.Now, endDate = DateTime.Now },
- commandType: CommandType.StoredProcedure,
- commandTimeout: 900) as List<ReportResponse>;
- CREATE FUNCTION Availability_List(facilityId int, startDate date, endDate date)
- RETURNS report_type[]
- AS
- $$
- DECLARE
- result_record report_type[];
- BEGIN
- result_record := array(
- SELECT...
- );
- RETURN result_record;
- END $$ LANGUAGE plpgsql;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement