Setting number of rows with postgresql

[SinNisTeR]

Edit: i thought i might aswell reuse this old thread.

How do i set the maximum rows that a table can have? I'm trying to have it automatically delete everything that is old in the table. Would a better approach be having a trigger that automatically deletes things after table reaches certain size? how would i do that?

 

[kamper]

Here's the official reference: http://www.postgresql.org/docs/8.0/interactive/datatype-datetime.html I don't see anything about being able to specify a template format.

I think usually the easiest way to specify dates is in yyyy-mm-dd format.

Oh, and here's a more technical reference: http://www.postgresql.org/docs/8.0/interactive/datetime-appendix.html

 

[SinNisTeR]

ya.. i read those, just curious if there was a way. thanks.

 

[SinNisTeR]

bump, new question

 

[SinNisTeR]

?