get_subscriptions_paginated(p_user_id integer, p_offset integer DEFAULT 0, p_limit integer DEFAULT 10)


Description

Retrieves subscriptions for a user with pagination, sorted by subscription date.

Parameters

Name Type Mode
p_user_id integer IN
p_offset integer IN
p_limit integer IN
streamer_id integer TABLE
username citext TABLE
subscribed_since timestamp without time zone TABLE

Definition