From: Andreas <maps.on@gmx.net>
To: Andrei Bintintan <klodoma@ar-sd.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: where to start with this procedure ?
Date: Thu, 20 May 2004 16:46:34 +0200
Message-ID: <40ACC4CA.4080406@gmx.net> (raw)
In-Reply-To: <00bb01c43e3a$7d33f980$0b00a8c0@forge>
References: <40ABFCDE.8020601@gmx.net>
<00bb01c43e3a$7d33f980$0b00a8c0@forge>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: maps.on@gmx.net, klodoma@ar-sd.net
Subject: Re: where to start with this procedure ?
In-Reply-To: <40ACC4CA.4080406@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox