Hello All! Ran into an issue and was hoping to get some feedback. I have a postgres db table with columns for 'users', 'email' and '4 digit number' but when we migrated the data, it looks like any leading zero's were dropped from the '4 digit number' column. e.g. if User A had a '4 digit number' of…

@ScottR Thanks for your reply! I got some inspiration and a little more digging and was able to run the query below and it worked! (by the way: can't have leading zeros if the column type is BIGINT) update table set "4 digit number" = '0' || "4 digit number" where length("4 digit number") = 3; Th…

Postgres query by length

💬 Queries and Resources

ScottR February 3, 2022, 6:15pm 4

well done!

1 Like

Topic		Replies	Views
Error postgresql bigint 💬 Queries and Resources	14	3100	July 27, 2023
Retool treats Postgres some numeric types as strings 💬 Feature Requests	12	3760	May 5, 2023
Save Changes to bulk update a table with primary key 💬 Queries and Resources javascript , sql	5	4101	August 2, 2023
SQL - Number is a String 💬 App Building bug , sql	5	1471	August 2, 2023
If I select multiple rows in a table, how do I mass update them in Retool PostgreSQL database? 💬 Queries and Resources	5	3904	June 26, 2023

Postgres query by length

Related topics