Loss of data accuracy after inserting data

[eric-gitta-moore]

-0.2454550117254257 before => -0.24545501 after

docker image: tensorchord/pgvecto-rs:pg14-v0.2.0@sha256:739cdd626151ff1f796dc95a6591b55a714f341c737e27f045019ceabf8e8c52

It's like a magic spell. I have no idea at all what happened in the middle

immich=# insert into "smart_search" ("assetId", "embedding")
values ('aff7212e-8e29-4d1c-8daf-5608f2ff01ec',
        '[-0.2454550117254257,-0.1832132041454315,0.0998565554618835,.................]')
on conflict ("assetId") do update set "embedding" = "excluded"."embedding";
immich=# select * from smart_search;
               assetId                |                                    embedding                                    
--------------------------------------+---------------------------------------------------------------------------------
 aff7212e-8e29-4d1c-8daf-5608f2ff01ec | [-0.24545501, -0.1832132, 0.099856555, -0.15989304, 0.07946199, -0.012376433, -.
                                      |.0.03624209, -0.46649158, -0.011027507, -0.112675495, -0.36174533, 0.09534826, 0.
immich=# \dx
                                              List of installed extensions
     Name      | Version |   Schema   |                                   Description                                   
---------------+---------+------------+---------------------------------------------------------------------------------
 cube          | 1.5     | public     | data type for multidimensional cubes
 earthdistance | 1.1     | public     | calculate great-circle distances on the surface of the Earth
 pg_trgm       | 1.6     | public     | text similarity measurement and index searching based on trigrams
 plpgsql       | 1.0     | pg_catalog | PL/pgSQL procedural language
 unaccent      | 1.1     | public     | text search dictionary that removes accents
 uuid-ossp     | 1.1     | public     | generate universally unique identifiers (UUIDs)
 vectors       | 0.2.0   | vectors    | vectors: Vector database plugin for Postgres, written in Rust, specifically des.
               |         |            |.igned for LLM
(7 rows)

[VoVAllen]

Can you elaborate more about your issue? I don't understand what's the problem here

[eric-gitta-moore]

Sorry, maybe I didn't describe it clearly enough. It should be more clear in the psql command I posted below.
In the insert statement, the first item of the vector array is -0.2454550117254257.
However, after the upsert operation, when querying again, the result was -0.24545501.
What I want to know is where the missing several digits 17254257 at the end have gone?

[VoVAllen]

PostgreSQL by default limits the number of digits shown for floating-point numbers. You can increase the display precision by setting the extra_float_digits parameter:

SET extra_float_digits = 15;