[SQL] Re: [GENERAL] Porting from mysql to psql (UNIX_TIMESTAMP()?)

2000-09-09 Thread Zlatko Calusic
Zlatko Calusic <[EMAIL PROTECTED]> writes: > Is there any similar functionality (returning unixish number of > seconds since 1970 from the timestamp field) in PostgreSQL? It's amazing that I spent something like an hour trying to find an answer, and only ten minutes waiting for

[SQL] Porting from mysql to psql (UNIX_TIMESTAMP()?)

2000-09-09 Thread Zlatko Calusic
Hi! As subject says, we are currently porting all of our data, programs and logic from mysql to postgresql. One of the things we have yet to resolve is how to replace mysql's UNIX_TIMESTAMP() function we used extensively in PosgreSQL? Function works like this in mysql: mysql> select start from

Re: [SQL] Optimizing huge inserts/copy's

2000-09-05 Thread Zlatko Calusic
Jie Liang <[EMAIL PROTECTED]> writes: > Hi, there, > > I tried different ways, include vaccum table , ensure index works, it > still is as slow as ~100rows per minute. > PGFSYNC=no in postmaster.init? Well, this might be Debian Linux specific, pardon me if it is. I have just begun playing