aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_select_room_id_by_roomnumber
Parameters
Name
Type
Mode
room_number
text
IN
Definition
declare v_result integer; BEGIN select r.id into v_result from room r where upper(r.room_number)=upper($1) -- where r.room_number=$1 limit 1 ; return coalesce(v_result, 0); END;