Re: partial index on non default tablespace syntax

Rajesh Kumar Mallah <mallah.rajesh@gmail.com> writes:
> Looks like its not possible to specify tablespace of an index with a
> where clause,

Hm?

regression=# create table foo(f1 int, f2 int);
CREATE TABLE
regression=# create index fooi on foo (f1) tablespace pg_default where f2 < 0;
CREATE INDEX

(I hadn't bothered to make a tablespace to test with, but the point
is the syntax is fine.)
        regards, tom lane