I'm running into the same issue as well. Did you find a solution?
g
garyaustin
02/11/2022, 12:12 AM
@User@User
If I understand the question you want an int8 column to show up in js as a string because js won't handle the int8 if large number. You can cast a column in .select('col::text') part of supabase js call.
n
n
02/11/2022, 1:51 AM
great, thank you!
can we cast strings as int8/bigint on
.insert
as well?
g
garyaustin
02/11/2022, 2:15 AM
I personally have not tried it, but one would think so. This is all pretty much postgrest.org stuff. There are some limits on filters if I recall.
@User I did a quick test and I could not get any sort of ::cast to work with the javascript object on an update, BUT just doing .update({number:'5020888899833'}) was converted into an int8 column correctly.