Hyperstage supports the DELETE statement. For more information, see the PostgreSQL 9.2 Documentation.

DELETE FROM tbl_name    [WHERE where_condition]
    [ORDER BY ...]
    [LIMIT row_count]

AUTOCOMMIT is also important for good DELETE performance. DELETE is designed to remove the older data from a table and free up disk space. It should be used sparingly to randomly delete data over a large fact table as this may cause a performance impact over time.

Occasionally, data is incorrectly loaded to a fact table. DELETE can be used effectively in this case to remove the fresh incorrect data and replace it with the corrected data.

WebFOCUS