Partitioning by letter question
| От | John Lister |
|---|---|
| Тема | Partitioning by letter question |
| Дата | |
| Msg-id | 4B636022.90804@kickstone.com обсуждение исходный текст |
| Ответы |
Re: Partitioning by letter question
|
| Список | pgsql-sql |
Hi, I was wondering if this was possible. I'm trying to partition a table, which is straightforward enough thanks to the great documentation, but i have a question: If I partition using something like a product_id for example and have check constraints such as (id>=1000 and id<2000) then everything is fine and the planner correctly uses the right subset of the tables. However I would like to partition by the first letter and using something like this substr(word,1,1)='a' is ignored by the planner. From reading the docs I understand that complicated check constraints are ignored, but this doesn't seem overly complicated. Am i doing something wrong or is there another better way to do this Thanks John
В списке pgsql-sql по дате отправления: