select Quote_delete('IBM', date('02-Nov-2013')); quote_delete -------------- 2 (1 row) select Quote_count('IBM'); quote_count ------------- 3 (1 row) select Day from Quote_get('IBM'); day ----------------------------------------- date:{11-04-2013,11-05-2013,11-06-2013} (1 row) select Quote_delete('ABB', date('03-Nov-2013'), date('06-Nov-2013')); quote_delete -------------- 2 (1 row) select Quote_truncate(); quote_truncate ---------------- (1 row) select Quote_count('IBM'); quote_count ------------- 0 (1 row) select Quote_count('ABB'); quote_count ------------- 0 (1 row) select * from Quote_get('IBM'); symbol | day | open | high | low | close | volume --------+---------+-----------+-----------+-----------+-----------+--------- IBM | date:{} | float4:{} | float4:{} | float4:{} | float4:{} | int4:{} (1 row) select * from Quote_get('ABB'); symbol | day | open | high | low | close | volume --------+---------+-----------+-----------+-----------+-----------+--------- ABB | date:{} | float4:{} | float4:{} | float4:{} | float4:{} | int4:{} (1 row) select Quote_drop(); quote_drop ------------ (1 row)