[RESOLVED] How to get OLDEST row in table and DELETE it.

One of my columns is

created_at

created_at

which is a

timestampz

timestampz

type and I need to check whether the count of my table is above 500. if so then delete the oldest row.

Supabase Join

Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.

45,816Members

Resources

Recent Announcements

Similar Threads

Was this page helpful?

Twitter GitHub Discord

Communities Docs About Terms Privacy

Star

Setup for Free