Changes between Version 2 and Version 3 of Напредна

Timestamp:

06/14/26 19:32:51 (3 days ago)

Author:

231233

Comment:

--

Напредна

@@ -8 +8 @@
 
 Инсталација
+
 Visual Studio Installer → Modify → Workloads → Desktop Development with C++
+
 Отвори x64 Native Tools Command Prompt as Administrator и изврши:
+
 set "PGROOT=C:\Program Files\PostgreSQL\16"
 cd %TEMP%
@@ -18 +21 @@
 
 Во pgAdmin изврши:
+
 CREATE EXTENSION vector;
 
 Креирање табели:
+
 CREATE TABLE movie
 (
@@ -37 +42 @@
 
 Внесување податоци:
+
 INSERT INTO movie(title, genre)
 VALUES ('Fast Racing', 'Action'),
@@ -48 +54 @@
 
 Similarity search (Euclidean):
+
 SELECT movie.title,
        embedding <-> '[0.90, 0.80, 0.10, 0.20]' AS distance
@@ -55 +62 @@
 
 SQL функција за similarity search:
+
 CREATE OR REPLACE FUNCTION search_movies_by_embedding(query_embedding vector(4))
     RETURNS TABLE(title TEXT, distance FLOAT)
@@ -86 +94 @@
 
 Cosine similarity search:
+
 SELECT movie.title,
        embedding <=> '[0.90, 0.80, 0.10, 0.20]' AS cosine_distance