Home > front end >  SELECT after specific row with non-sequential (uuid) primary key
SELECT after specific row with non-sequential (uuid) primary key

Time:09-16

With the following table:

CREATE TABLE users (
    id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
    inserted_at timestamptz NOT NULL DEFAULT now()
    -- other fields
);

How could I retrieve n rows after a specific id, ordered by inserted_at ?

CodePudding user response:

I want to retrieve n rows after a specific id, ordered by inserted_at.

I am expecting something like this:

select u.*
from users u
where u.inserted_at > (select u2.inserted_at from users u2 where u2.id = 'f4ae4105-1afb-4ba6-a2ad-4474c9bae483')
order by u.inserted_at
limit 10;

For this, you want one additional index on users(inserted_at).

  • Related