Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
Hi, I wonder how could it be possible to extract partitions that contains a peculiar item Consider 4 partitions 1, 2, 3, 4 with different items A, B, C... inside P item1 A1 B1 C2 B2 D2 G2 H3 B3 C4 X4 D4 Z How could a select return partitions 2,4 because they both contains D item ? As a result, I would get : 2 B2 D2 G2 H4 X4 D4 Z I can filter partitions with lag, lead, nth_value... but how could I write something like "select P,any (item=D) over (partition by P) from..." Thanks for any help, Garanti sans virus. www.avast.com
Hi,
I wonder how could it be possible to extract partitions that contains a peculiar item
Consider 4 partitions 1, 2, 3, 4 with different items A, B, C... inside
P item
1 A
1 B
1 C
2 B
2 D
2 G
2 H
3 B
3 C
4 X
4 D
4 Z
How could a select return partitions 2,4 because they both contains D item ?
As a result, I would get :
I can filter partitions with lag, lead, nth_value... but how could I write something like "select P,any (item=D) over (partition by P) from..."
Thanks for any help,
В списке pgsql-admin по дате отправления: