LANGUAGE sql function returns 0 rows; identical inlined body and identical plpgsql function both return rows
Ellie Nartey reports an issue where a LANGUAGE sql function returns 0 rows, while an identical inlined body and a plpgsql function return 3 rows. This occurs under the same transaction and role. The issue persists despite dropping and recreating the function. Ellie seeks insights into potential causes related to pooler, prepared-statement, or plan-cache mechanisms, and pgvector operator resolution issues.