Partition by list - is select possible? - Mailing list pgsql-sql

From Mike Martin
Subject Partition by list - is select possible?
Date
Msg-id CAOwYNKZNqvh=UOEBaH-YBOx3jATfn_cVpy9XKJdvVkHJ8B7ShQ@mail.gmail.com
Whole thread Raw
Responses Re: Partition by list - is select possible?  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-sql
Simple question - is it possible to have a select query providing the values for a list partitioned table? ie:

CREATE TABLE testpart (fileid int,tagname text,tagvalue text[])
PARTITION BY LIST (tagname);
CREATE TABLE testpart_tag PARTITION OF testpart
    FOR VALUES  IN (SELECT tag FROM tagmap);
CREATE TABLE testpart_def PARTITION OF testpart
    DEFAULT;

thanks

Mike

pgsql-sql by date:

Previous
From: Martin Handsteiner
Date:
Subject: AW: Optimizer Hint, to ignore limit and offset in optimizer plan
Next
From: David Rowley
Date:
Subject: Re: Partition by list - is select possible?