我有一个这样的数组：
["f383224c-aa95-40c9-a4e4-fa41747f49c5","c783234c-aa95-40c9-a4e4-fa41747f49c6"]
我想选择任意但我收到错误无法将文本[]转换为uuid
SELECT c.name FROM cars c
LEFT JOIN location_orders_cars loc ON loc.car_id = c.id
WHERE loc.user_id = ANY($1::uuid) AND loc.location_orders_id = $2 AND loc.is_back = NULL
LIMIT 10;
$1 = 上述 UUID 数组
2美元=355
我在这里做错了什么？
使用 date_part 时出现此错误
error: function date_part(timestamp without time zone, unknown) does not exist
有时我会得到一个时间戳值，有时却为空。那么如何处理空值呢？
SELECT u.id as user_id
, u.firstname
, u.lastname
, c.id as company_id
, c.company
, wt.start_time as available_at
, wt.end_time as available_until
FROM users u
LEFT JOIN workers_times wt
ON wt.user_id = u.id
LEFT JOIN clients c
ON c.id = u.company_id
WHERE u.tenant_id = $2
AND u.deleted_by IS NULL
AND DATE_PART(wt.work_date, 'month') = 4
AND DATE_PART(wt.work_date, 'day') = 11
GROUP BY u.id
ORDER BY u.id DESC
, u.created_by DESC
LIMIT 100
我有一个条件，我想获得两个日期之间的结果：
start_time: 2025-01-02
end_time: 2025-04-27
问题是我没有得到结果2025-04-27，我得到了2025-04-26，所以它提前一天结束。我还想获取时间2025-04-27
我做错了什么？
SELECT l.id AS aslocation_id
, l.name
, lo.id
, lo.start_time
, lo.end_time
, lo.leader_id
, lo.is_storno
, lo.storno_at
, lo.storno_by
, lo.employees_need
, lo.created_at
FROM location_orders AS lo
JOIN location AS l ON l.id = lo.location_id
WHERE lo.tenant_id = 321
AND lo.deleted_by IS NULL
AND lo.start_time >= '2025-01-02'
AND lo.end_time <= '2025-04-27'
ORDER BY lo.start_time DESC
, lo.id DESC
LIMIT 50;
我有一个应用程序，用户可以在其中创建订单。我想向他显示今天的订单，然后按正常方式订购。像这样：
今天的日期：2024-04-06
2024-04-06 #order1
2024-04-06 #order2
-then sort by normal
2024-04-08 #order4
2024-04-01 #order7
我脑子里在想的是，如果我按正常排序，那么我的日期会显示重复？我的意思是，首先是 2024-04-06，然后我从 2024-04-08 开始按正常排序，然后向下排序，然后再次到达 2024-04-06。那么，是否可以先按今天排序，然后再按其余排序，而不会显示重复？
目前这是我的代码：
SELECT
l.id as location_id,
l.name,
lo.id,
lo.start_time,
lo.end_time,
lo.leader_id,
lo.is_storno,
lo.storno_at,
lo.storno_by,
lo.employees_need,
lo.created_at
FROM location_orders lo
INNER JOIN location l
ON l.id = lo.location_id
WHERE lo.tenant_id = $1 AND lo.deleted_by IS NULL
ORDER BY lo.start_time DESC LIMIT 50;