Message-ID: <40ACC4CA.4080406@gmx.net>
Date: Thu, 20 May 2004 16:46:34 +0200
From: Andreas <maps.on@gmx.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT;
	rv:1.7b) Gecko/20040316
MIME-Version: 1.0
To: Andrei Bintintan <klodoma@ar-sd.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: where to start with this procedure ?
References: <40ABFCDE.8020601@gmx.net> <00bb01c43e3a$7d33f980$0b00a8c0@forge>
In-Reply-To: <00bb01c43e3a$7d33f980$0b00a8c0@forge>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


Hi Andrei,


>Use the Offset and Limit in the SQL query.
>[...]
>SELECT select_list
>    FROM table_expression
>    WHERE condition
>    LIMIT 50
>    OFFSET 10000
>
>This query will return 50 elements starting with the 10000 elements... so
>the elemenst from 10000 to 10050.
>  
>

That isn't the issue since I only need a specific few of the lines at all.
I need a dynamic WHERE clause.

It's more like this :
SELECT customer_id, and, some, more, fields
FROM  table1
             JOIN table2
                       JOIN table3
        ....

This results in the "huge" set.
On the Access-form I only need the orders, or contact history for 1 
customer.

As of now I only know 2 ways to solve this.
1) Load all the tables over the net into Access and let the JOIN run 
locally. That way I can filter dynamically by adding a   WHERE 
customer_id = x   to the select above.
2) Let the JOINS run in a server based view and transfer the whole 
result into Access to fetch the few lines regarding the customer.

There should be something like:
3)
a) Access calls a server based function with the customer_id as parameter.
b) The function calls the server based view and filters the result 
acording to it's parameter.
c) The function sends only the actually wanted lines back to Access.