Fuhr,Tom and Everyone Extremely sorry for not consulting the docs. I was doing this:
CREATE INDEX foo_name_idx ON foo (name) WHERE name IS NOT NULL TABLESPACE testspace ; Regds Rajesh Kumar Mallah. On 6/18/05, Michael Fuhr <[EMAIL PROTECTED]> wrote: > 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/ > ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
