PostgreSQL UUID fuzzy search UUID string type conversion SQL error [42883] explicit type casts

Problem description

stay postgresql In the course of using , You may have the following needs ：

• Right uuid Filter columns of type , But you need to manually enter the whole uuid Too much trouble makes mistakes , If uuid It's good that columns can match as vaguely as strings
• Yes uuid Columns are directly fuzzy matched , Will report a mistake SQL Error [42883]
• Is there any way to uuid/ String type ？
• If you can convert types ,postgresql What other types are there ？

uuid Fuzzy search Variable / Column value type conversion

Right postgresql Filter a table in , Filter field is id uuid,uuid It's hard to input manually , If you can be right uuid It's good to fuzzy match the columns of type .

select * tbl_user where id = 'bf9d1fdb-d9fb-4a99-86cb-df46e2410a33';

--  Will report a mistake  SQL Error [42883]
select * tbl_user where id like 'bf9d1fdb-d9fb-4a99-86cb-df46e2410a33';

--  take id The column is treated as a specified type -->character varying, Then it is actually fuzzy matching of strings 
select * tbl_user where id::character varying like 'bf9d1fdb-d9fb-4a99-86cb-df46e2410a33';
--  Fuzzy matching can be used  _ %  Equal matching symbol .
select * tbl_user where id::character varying like 'bf9d1fdb%';

• SQL Error [42883]

org.jkiss.dbeaver.model.sql.DBSQLException: SQLException: SQL Error [42883]: ERROR: operator does not exist: uuid
-- unknow Hint: No operator matches the given name and argument types. You might need to add explicit type casts.

Form like :: data type Writing , You can set variables / Column / Value for type conversion . That is to say explicit type casts Explicit type conversion .

Quiz

select 'ddff338c-4ee2-41e7-9216-6ca9dbd03738', 'ddff338c-4ee2-41e7-9216-6ca9dbd03738'::uuid, 'ddff338c-4ee2-41e7-9216-6ca9dbd03738'::character varying ;
above SQL We'll find out 3 Column 1 The result set of rows . The problem is ： What is the data type of each column ？

character string
UUID
character string

More types

Do you want to know something like this :: data type Writing , What other type names can be written ？
see https://www.postgresql.org/docs/current/datatype.html

DBeaver The screenshot of the interface will be added when free .