View Single Post

   
  #6 (permalink)  
Old 04-11-2008, 03:41 AM
Hannu Krosing
 
Posts: n/a
Default Re: ARCHIVE TABLES (was: possible TODO: read-only

On E, 2005-05-02 at 15:59 -0500, Jim C. Nasby wrote:
> Out of curiosity, what would be required to allow deletes (but not
> updates)?


Perhaps a "CLUSTER indexname ON tablename WHERE xxx" could be used for
that.

That is a CLUSTER command that leaves out the tuples which do not
satisfy "xxx".

--
Hannu Krosing <hannu@skype.net>


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Reply With Quote