SupabaseS
Supabase•5mo ago
ytomtom

`update().select().limit(1).single()` behavior not consistent

Hi we have two supabase projects. One's on postgres v15.1.1.73, the other is on v17.4.1.069.

on the v17, this works, on v15 it doesn't
 await supabase
    .from('Table')
    .update({
      foo: true,
      bar: true,
      baz: true
    })
    .eq('id', userID)
    .select('*')
    .limit(1)
    .single();


to get it to work on v15, we had to remove the limit(1)

 await supabase
    .from('Table')
    .update({
      foo: true,
      bar: true,
      baz: true
    })
    .eq('id', userID)
    .select('*')
    .single();


Is this a postgrest version issue?
Was this page helpful?