[Babase] rain gauge rounding

Karl O. Pinc kop at meme.com
Wed Jul 29 17:16:43 EDT 2009


On 07/29/2009 02:30:23 PM, Niki Learn wrote:

> Ah.  Maybe that is why the numbers are off more than we expected - 
> who
> knows?  I can probably do the rounding - then I can also take a short
> time
> to add the most recent data before I upload.  

Sounds like a plan.
> 
> What is the best way to delete the previously uploaded version?

The fastest way is to use the TRUNCATE statement.
I think there's a PPA button.  The DELETE statement
will work fine too but is marginally slower
because it does all the consistency checks.

http://www.postgresql.org/docs/8.1/static/sql-truncate.html
http://www.postgresql.org/docs/8.1/static/sql-delete.html

I see you need to be table owner to use TRUNCATE, so you
probably want DELETE.

DELETE FROM tempmins;
DELETE FROM raingauges;
etc.

Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein




More information about the Babase mailing list