Hi Oliver,
 
You can use tableoid system column of table for filtering.
 
select tableoid::regclass,* from parent_table where tableoid::regclass in ('p2','p4');
 
https://www.postgresql.org/docs/10/static/ddl-system-columns.html
 
Best regards.


İyi çalışmalar.
Samed YILDIRIM



13.02.2018, 18:08, "Olivier Leprêtre" <o.lepretre@gmail.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 :

 

2 B

2 D

2 G

2 H

4 X

4 D

4 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