Supabase default text value is set incorrectly
In my table I have a
But when I put
and then it save it like that as default. So in my db instead of version
The value is not nullable, the type is text and default should only be
I tried to save it as
How can I have it saved as
version column where I want a default value to be set to 1.0 of type text if version is not being set by user explicitly.But when I put
1.0 for default and hit save it will convert to '1.0'::textand then it save it like that as default. So in my db instead of version
1.0 it will be saved as '1.0'::textThe value is not nullable, the type is text and default should only be
1.0 I tried to save it as
1 but it will be saved as '1'::text, also tried with setting it as "1" or '1' but then it will be saved as '"1"'::text or ''1''::textHow can I have it saved as
1.0 only?
