lobos icon indicating copy to clipboard operation
lobos copied to clipboard

Creation of partial indexes

Open andyparsons opened this issue 10 years ago • 0 comments

Hello- is there any way to create partial indexes with Lobos? Something like this:

CREATE UNIQUE INDEX favo_3col_uni_idx ON favorites (user_id, menu_id, recipe_id) WHERE menu_id IS NOT NULL;

CREATE UNIQUE INDEX favo_2col_uni_idx ON favorites (user_id, recipe_id) WHERE menu_id IS NULL;

andyparsons avatar Jun 06 '15 18:06 andyparsons