aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_get_block_rooms
Parameters
Name
Type
Mode
booking_id
integer
IN
boooking_item
integer
IN (DEFAULT NULL)
Definition
SELECT string_agg(room_number, ', ' ORDER BY room_number) FROM room_block rb LEFT JOIN room rm on rm.id = rb.room_id WHERE rb.booking_id = $1 AND ($2 IS NULL OR rb.booking_item = $2) AND rb.status = 'B' ;