@Query(value = "SELECT ST_Distance(" +
"ST_SetSRID(ST_MakePoint(:userLng, :userLat), 4326), " +
"ST_SetSRID(ST_MakePoint(:hotelLng, :hotelLat), 4326)" +
") AS distance", nativeQuery = true)
Double hotelDistanceBetweenUser2(@Param("userLng") Double userLongitude,
@Param("userLat") Double userLatitude,
@Param("hotelLng") Double hotelLongitude,
@Param("hotelLat") Double hotelLatitude);
@Query(value = "SELECT ST_Distance(" +
"ST_SetSRID(ST_MakePoint(:userLng, :userLat), 4326), " +
"ST_SetSRID(ST_MakePoint(:hotelLng, :hotelLat), 4326)" +
") AS distance", nativeQuery = true)
Double hotelDistanceBetweenUser2(@Param("userLng") Double userLongitude,
@Param("userLat") Double userLatitude,
@Param("hotelLng") Double hotelLongitude,
@Param("hotelLat") Double hotelLatitude);