Re: [SQL] how to download linux 7.3 image

2007-07-23 Thread Aarni Ruuhimäki
On Monday 23 July 2007 01:03, Jean-David Beyer wrote: > Mohd Ghalib Akhtar wrote: > > how to download linux 7.3 image file(means os) ? > If you want a Red Hat looking product, you should consider running the > latest version of Fedora. > You might also want to try CentOs, 'an Enterprise-class Lin

Re: [SQL] Database Synchronization

2007-07-23 Thread Jyoti Seth
Hello, When I am installing slony-I from rpm's available at the following url:http://main.slony.info/downloads/1.2/rpm/ it is giving an error: There are no installable providers of postgresql-slony1-engine. In our system postgresql has been installed through YAST. So when we try to install and co

Re: [SQL] The nested view from hell - Restricting a subquerry

2007-07-23 Thread Gregory Stark
Nis Jørgensen <[EMAIL PROTECTED]> writes: >>> Well, the query can be satisfied by looking only at the rows with an >>> order_id matching the invoice_id given. The condition that this is the >>> largest invoice in the group then needs to be checked afterwards. >>> >>> I certainly did not expect the

Re: [SQL] The nested view from hell - Restricting a subquerry

2007-07-23 Thread Nis Jørgensen
Gregory Stark skrev: >> 1. Look up all order_ids for which (order_id,my_invoice_id) appear in >> eg_orders >> >> 2. Find all rows (in both branches of the UNION) with these id_s >> >> 3. Group the rows, and calculate max(invoice_id) >> >> 4. Filter the result rows on max(invoice_id) = my_invoice_i

Re: [SQL] The nested view from hell - Restricting a subquerry

2007-07-23 Thread Gregory Stark
"Gregory Stark" <[EMAIL PROTECTED]> writes: > Nis Jørgensen <[EMAIL PROTECTED]> writes: > >> 1. Look up all order_ids for which (order_id,my_invoice_id) appear in >> eg_orders >> >> 2. Find all rows (in both branches of the UNION) with these id_s Oh, did you mean look up the order_ids for which t

Re: [SQL] Database Synchronization

2007-07-23 Thread Andrew Sullivan
On Mon, Jul 23, 2007 at 02:55:21PM +0530, Jyoti Seth wrote: > In our system postgresql has been installed through YAST. So when we try to > install and configure slony-I through source, it gives the message please > make sure tp build and install postgresql from the sources first. > You _might_ b