Β© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabaseβ€’4y agoβ€’
9 replies
wolf5

difference between rangeGt(), rangeGte(), rangeLt(), rangeLte(), rangeAdjacent()

I want to filter data by dates just like the following doc.
Is the following doc accurate?
https://supabase.com/docs/reference/javascript/rangegt
const { data, error } = await supabase
  .from('reservations')
  .select()
  .rangeGt('during', '[2000-01-02 08:00, 2000-01-02 09:00)')
const { data, error } = await supabase
  .from('reservations')
  .select()
  .rangeGt('during', '[2000-01-02 08:00, 2000-01-02 09:00)')


This gives me an error
error >>> {"code":"42883","details":null,"hint":"No operator matches the given name and argument types. You might need to add explicit type casts.","message":"operator does not exist: timestamp with time zone >> unknown"}
error >>> {"code":"42883","details":null,"hint":"No operator matches the given name and argument types. You might need to add explicit type casts.","message":"operator does not exist: timestamp with time zone >> unknown"}
rangeGt()
rangeGt()
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Difference between offical JWT
SupabaseSSupabase / help-and-questions
4y ago
Difference between stream() and onPostgresChanges()
SupabaseSSupabase / help-and-questions
3y ago
Difference between Docker and Clould
SupabaseSSupabase / help-and-questions
4y ago
Difference between edge functions and webhooks
SupabaseSSupabase / help-and-questions
4y ago