Re: partial index on non default tablespace syntax - Mailing list pgsql-sql

On Sat, Jun 18, 2005 at 10:24:06PM +0530, Rajesh Kumar Mallah wrote:
> 
> Looks like its not possible to specify tablespace of an index with a
> where clause,

Could you show the command you're running and the error you get,
or otherwise explain what problem you're seeing?  Is the following
not what you're looking for?

CREATE INDEX foo_name_idx ON foo (name) TABLESPACE testspace WHERE name IS NOT NULL;

http://www.postgresql.org/docs/8.0/static/sql-createindex.html

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/