By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 8.0.19 |
create table workspaces (id bigint, name varchar(16))
insert into workspaces values (1, 'ONE');
insert into workspaces values (2, 'TWO')
SELECT * FROM workspaces WHERE id = '1';
| id | name |
|---|---|
| 1 | ONE |
SELECT * FROM workspaces WHERE id = '1.a';
| id | name |
|---|---|
| 1 | ONE |
SELECT * FROM workspaces where id = 'a';