On Tue, Jun 21, 2011 at 1:52 PM, David Fetter <da...@fetter.org> wrote: >> Still, I think a pretty clear >> way forward here is to try to figure out a way to add some explicit >> syntax for range partitions, so that you can say... >> >> foo_a is for all rows where foo starts with 'a' >> foo_b is for all rows where foo starts with 'b' >> ... >> foo_xyz is for all rows where foo starts with 'xyz' >> >> If we have that data represented explicitly in the system catalog, >> then we can look at doing built-in INSERT-routing and UPDATE-handling. >> For an added bonus, it's a more natural syntax. > > Does someone else have such a syntax? Does The Standard™ have > anything to say?
Yes, and I don't know, respectively. There have been previous discussions of this. You might want to start by reading the discussion around the previous patch. https://commitfest.postgresql.org/action/patch_view?id=266 -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
