Re: [ADMIN] Regarding backups

2005-07-08 Thread Bruno Wolff III
On Sat, Jul 09, 2005 at 01:19:38 +0530, nandan bsd <[EMAIL PROTECTED]> wrote: > Hi, > > Please let me know, if there are any differential or incremental > backups in postgres > If any let me know the process. You can use backups of your WAL files since the last file system backup was started to

[ADMIN] Regarding backups

2005-07-08 Thread nandan bsd
Hi, Please let me know, if there are any differential or incremental backups in postgres If any let me know the process. Thanks Nand ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] where with NULL values are not selected

2005-07-08 Thread Enrico Weigelt
* Dawid Kuroczko <[EMAIL PROTECTED]> wrote: > A hint: > qnex=# SELECT 'ok' WHERE NULL=NULL; > ?column? > (0 rows) > > In other words -- NULL is not equal to NULL. NULL is not a value, NULL > is a state. If you want to join those columns, you cannot use NULL > as a joining key. It's the way SQ

Re: [ADMIN] where with NULL values are not selected

2005-07-08 Thread Dawid Kuroczko
On 7/8/05, Düster Horst <[EMAIL PROTECTED]> wrote: > I try to join two tables whereas some column values do have NULL values with > the following query: > > select table1.column from table1, table2 where table1.column=table2.column > > table1.column and table2.column may have NULL values. The pro

Re: [ADMIN] where with NULL values are not selected

2005-07-08 Thread Peter Eisentraut
Am Freitag, 8. Juli 2005 12:08 schrieb Düster Horst: > table1.column and table2.column may have NULL values. The problem is that > these columns where not selected. Does there exists any solution to > select/join the NULL value colums also. Read up on outer joins. In your case, try this: select

[ADMIN] where with NULL values are not selected

2005-07-08 Thread Düster Horst
I try to join two tables whereas some column values do have NULL values with the following query: select table1.column from table1, table2 where table1.column=table2.column table1.column and table2.column may have NULL values. The problem is that these columns where not selected. Does there exist

[ADMIN] doubt

2005-07-08 Thread Mogin Mohandas
Hi When I try to run 'make install' it gives me an "error 2". Any idea about error 2. I guess it has something to do with initdb. Here is portions of the error: make[2]: *** [installdirs] Error 2 make[2]: Leaving directory `/home/mmohanda/postgres/postgresql-7.4.8/doc' make[1]: **