Filtering by UUID

From: Colin Morelli <colin(dot)morelli(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Filtering by UUID
Date: 2016-09-29 23:03:19
Message-ID: CAPtU-UrkgRAJ1iMYFKBjtPZthmmQtkw-H9mJHKi-VX_kV2jHZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey list,

I'm using UUID primary keys in my application. I need to add pagination,
and am trying to avoid OFFSET/LIMIT. I do have a created_at timestamp that
I could use, but it's possible for multiple records to be created at the
same timestamp (postgres offers millisecond precision here, I believe?)

Is there an efficient way to filter based on the time component of UUID
v1s? WHERE id > 'some-uuid' doesn't seem to work, as it looks like it's
just performing a lexicographic sort on the hex representation of the UUID.
Or, alternatively, does anyone have other suggestions on paginating large
data sets?

Best,
Colin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guyren Howe 2016-09-29 23:08:47 Re: Filtering by UUID
Previous Message Tom Lane 2016-09-29 22:08:53 Re: [GENERAL] pg_upgrade from 9.5 to 9.6 fails with "invalid argument"