| | * Setzen Sie folgendes SELECT-Statement ab, um die 3 nächsten Einträge zu finden, der am nächsten zum Satz "Katzen sind meine Lieblingstiere" ist <WRAP><code psql>SELECT id, content, embedding <=> '[-0.03493, 0.03568, 0.06867, 0.00082, -0.04072, 0.06786, 0.11940, -0.05452, 0.02797, -0.04935, 0.02574, 0.03369, -0.00755, -0.09016, -0.03898, -0.08418, -0.07572, 0.12806, -0.06438, -0.02141, 0.01308, -0.00135, 0.04206, -0.01135, -0.03226, 0.00674, 0.03916, -0.02778, -0.02183, -0.06194, 0.11493, 0.00412, -0.04840, -0.03430, 0.05279, -0.04752, -0.00842, -0.05732, -0.00380, 0.02335, -0.10179, -0.06320, -0.09921, -0.07888, -0.01643, 0.05722, -0.01505, 0.01265, -0.03972, -0.00492, -0.05816, -0.01095, 0.05496, -0.03182, 0.05747, -0.10006, -0.00392, 0.03742, 0.01361, 0.04257, 0.10364, -0.00892, -0.01067, -0.01833, 0.00142, -0.04466, 0.06020, -0.05770, -0.05920, 0.02491, 0.07516, -0.08650, -0.02995, 0.02948, -0.04823, -0.05966, -0.07892, -0.03719, -0.04004, -0.09690, 0.00099, -0.00529, 0.05824, 0.02274, -0.04542, -0.03596, 0.01114, 0.05981, 0.05816, 0.03222, -0.03906, -0.04377, -0.12412, 0.00144, 0.10311, -0.05397, 0.01379, -0.03965, -0.04770, 0.08296, -0.02025, 0.02099, 0.05772, 0.08974, -0.02686, -0.10557, 0.03211, -0.06085, -0.01258, -0.01620, 0.03423, 0.01051, 0.07322, -0.10282, 0.07545, 0.00329, 0.07935, -0.03416, -0.00551, -0.00736, 0.06363, 0.03952, 0.06159, 0.11851, 0.02391, -0.04287, -0.03800, 0.00000, -0.03656, -0.00219, -0.03037, -0.00321, 0.01003, -0.05004, -0.11151, 0.02934, -0.05327, 0.03419, -0.02941, -0.03520, 0.00116, -0.03742, 0.00228, 0.02429, 0.00155, 0.05357, 0.05857, -0.06630, -0.01104, -0.01960, 0.09703, 0.06629, 0.00076, -0.04037, 0.05239, -0.01468, -0.05098, 0.00862, 0.08488, -0.04264, -0.01979, -0.05946, 0.00002, 0.03357, -0.06341, 0.03716, -0.02466, 0.01536, 0.04432, -0.01202, -0.02409, -0.06403, 0.02127, 0.08715, -0.00143, -0.00101, 0.04289, 0.00666, -0.00493, 0.04477, -0.02715, 0.00680, -0.01724, 0.10950, -0.02329, 0.01558, -0.04293, -0.01325, 0.04967, -0.05981, -0.05935, -0.05094, -0.02633, -0.00977, 0.01927, -0.02305, -0.00257, 0.07690, -0.11992, -0.01335, 0.05334, 0.05576, 0.01851, 0.00626, -0.07686, 0.08395, -0.01366, -0.03389, -0.05128, -0.05843, -0.00856, -0.05903, 0.02409, 0.01240, -0.06948, -0.03939, -0.02406, 0.09140, 0.00454, -0.03415, 0.01524, -0.03230, -0.02853, -0.00000, -0.03648, 0.02080, -0.05858, 0.06433, 0.02325, 0.06574, -0.05850, 0.06955, -0.06247, 0.02721, 0.00924, -0.07342, 0.01695, 0.03598, -0.02073, 0.05871, 0.04333, -0.03323, 0.03020, 0.01873, -0.09406, 0.03331, -0.02906, -0.01306, -0.08289, 0.02105, 0.03742, 0.05806, -0.02792, 0.02196, 0.04866, -0.01016, -0.05985, -0.05076, 0.00396, 0.06116, 0.01258, 0.06670, -0.01775, 0.06748, -0.06249, 0.06749, -0.00955, 0.02280, 0.06887, -0.02375, -0.04198, -0.06005, -0.01574, -0.02914, -0.01564, 0.05372, 0.01805, -0.03720, 0.00938, -0.00115, -0.03708, -0.03602, -0.09096, 0.04249, 0.00143, 0.07988, 0.09154, 0.01241, 0.02756, -0.03852, -0.09470, 0.00696, 0.11326, 0.04225, 0.00439, -0.05702, 0.01846, -0.00595, -0.12662, 0.00903, 0.07057, 0.12596, -0.03087, 0.00775, 0.05668, 0.01745, -0.00602, 0.01471, 0.04832, -0.01996, 0.06925, 0.00526, -0.02115, -0.00283, 0.01880, 0.06725, 0.04957, -0.02828, -0.01660, -0.00000, -0.00526, -0.08733, -0.09355, 0.00189, 0.09745, -0.07254, -0.04005, 0.00660, -0.11776, -0.01369, -0.00677, 0.01250, -0.04336, 0.05627, 0.04264, 0.03474, -0.09913, 0.06409, 0.01374, 0.00799, 0.09462, -0.01017, 0.00585, -0.04287, -0.04398, 0.05375, 0.02274, -0.07671, -0.01552, 0.02560, 0.02374, 0.12028, -0.04550, -0.02612, -0.04541, -0.01518, -0.02856, 0.00332, -0.06168, 0.03811, 0.05920, 0.04857, 0.09972, -0.04516, -0.00653, -0.05994, -0.03416, -0.03662, 0.09364, 0.07119, -0.01380, 0.05634, 0.03041, 0.09184, 0.03038, 0.05970, 0.00352, -0.00548, -0.06134, 0.02853, 0.01593, 0.08125, 0.04185, -0.04225]' AS distance FROM documents ORDER BY distance ASC LIMIT 3;</code></WRAP> |