Partition by list - is select possible?

From: Mike Martin <redtux1(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Partition by list - is select possible?
Date: 2020-07-08 10:31:55
Message-ID: CAOwYNKZNqvh=UOEBaH-YBOx3jATfn_cVpy9XKJdvVkHJ8B7ShQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Rowley 2020-07-08 12:01:08 Re: Partition by list - is select possible?
Previous Message Martin Handsteiner 2020-06-29 17:33:10 AW: AW: Optimizer Hint, to ignore limit and offset in optimizer plan