Re: [ADMIN] How do I do a dynamic - select now() + interval X days ?

2007-08-08 Thread Kristo Kaiv
or Systems Developer Media Matters for America http://mediamatters.org/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not

Re: [ADMIN] get the array content whis the select clause

2007-06-05 Thread Kristo Kaiv
i guess this what you meant: (not a nice solution though) writing a function that returns the set would be a better idea create table testintarr (iarr int[]); insert into testintarr values ('5,6,7,8'); test=# select iarr[idx] from (select iarr, generate_series(array_lower (iarr,1), array_upp

Re: [ADMIN] High Avaliable in the PostgreSQL.

2007-05-30 Thread Kristo Kaiv
Hi! We have a PostgreSQL cluster that is runnign on tens of server on different colocations. Failovers / switchovers between colocations can be done per server. Uptime has been >99.9%. All the software is opensource and has gone through intensive live testing. Our cluster is running on: s