Re: [GENERAL] limit left join rows to 1

2006-11-01 Thread Jure Ložar
Andreas Kretschmer wrote: Jure Ložar [EMAIL PROTECTED] schrieb: Hi. Is it possible to limit number of left join rows that match condition to 1? I don't want to have hits from first table multiplied when more then 1 row matches on left join condition. I'm not sure if i understand

[GENERAL] limit left join rows to 1

2006-10-31 Thread Jure Ložar
Hi. Is it possible to limit number of left join rows that match condition to 1? I don't want to have hits from first table multiplied when more then 1 row matches on left join condition. Thank you Jure ---(end of broadcast)--- TIP 6: explain

[GENERAL] How to read wal?

2005-12-30 Thread Jure Ložar
Hi. I have a big problem. I dropped wrong table. I do have very recent dump, but I would need to read wal (write ahead log) files somehow, to see last 60 entries that were made. Then I can enter them manually. Is there any way to make wal files more readable? Or is there something else that I