Rajesh Kumar Mallah <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
