8 lines
212 B
SQL
8 lines
212 B
SQL
SELECT *
|
|
FROM departments
|
|
CROSS APPLY (
|
|
SELECT dep_names.name_tsvector AS name
|
|
)
|
|
WHERE (
|
|
SELECT count(name_tsvector) FROM dep_names WHERE dep_names.id = departments.id AND dep_names.name_tsvector != NULL
|
|
) = 1; |