select exists(
select from unnest(array[1,2]) as city where not exists (select from T3 where id_сountry=1 AND id_city = city)
)select exists(values(1),(2) except select id_city from T3 where id_сountry=1 AND id_city IN (1, 2));select (select count(*) from T3 where id_сountry=1 AND id_city IN (1, 2)) = 2; -- где = 2 - число элементов в inpostgresql 11
SELECT * FROM messages WHERE NOT is_sentCREATE INDEX messages0 ON messages USING btree (is_sent) WHERE NOT is_sent
CREATE INDEX messages0 ON messages USING btree ((true)) WHERE NOT is_sent
CREATE INDEX messages0 ON messages USING btree (id) WHERE NOT is_sentEXECUTE format($$
COPY (
select %L
)
TO '/tmp/file';
$$, my_var);Если мы создадим составной индекс для этих колонок и будем искать значение
NEW.dt_update = NOW();
return NEW;И там, и там 16 линий вроде бы.
1 x PCIe 3.0/2.0 x16 (x16 mode, yellow)
1 x PCIe 2.0 x16 (x4 mode, ) *1
*1: The PCIe x16_2 slot shares bandwidth with PCIe x1_2 slot. The default setting is x2 mode. Go to the BIOS setup to change the settings.
melkij@melkij:~$ nc -l 8081
HEAD / HTTP/1.1
Host: 127.0.0.1:8081
User-Agent: curl/7.64.0
Accept: */*melkij@melkij:~$ nc -l 8081
GET / HTTP/1.1
Host: 127.0.0.1:8081
User-Agent: curl/7.64.0
Accept: */*без ее блокировки
select ... from (...) subquery order by ...
update my_table set all_child_qty = (select sum(child.qty) from my_table child where child.my_path LIKE (my_table.my_path || '%'));почему он не опознает переменную 'code' в подзапросе?