X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CBDFFD1B1BD for ; Wed, 19 May 2004 21:34:04 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 88368-06 for ; Wed, 19 May 2004 21:33:47 -0300 (ADT) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 82882D1B171 for ; Wed, 19 May 2004 21:33:43 -0300 (ADT) Received: (qmail 6118 invoked by uid 65534); 20 May 2004 00:33:45 -0000 Received: from p508BE830.dip.t-dialin.net (EHLO gmx.net) (80.139.232.48) by mail.gmx.net (mp009) with SMTP; 20 May 2004 02:33:45 +0200 X-Authenticated: #14269776 Message-ID: <40ABFCDE.8020601@gmx.net> Date: Thu, 20 May 2004 02:33:34 +0200 From: Andreas User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.7b) Gecko/20040316 X-Accept-Language: de-de, en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: where to start with this procedure ? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/174 X-Sequence-Number: 17888 Hi, I know a bit of SQL but not exactly a lot so I ran into this problem. I have tables on the server that get joined in a view. That's OK. Now I need just a couple of records say 10-100 of 30 000 which could easily be filtered by a integer key. As of now I have to pull the whole lot into Access and let it do the filtering. That doesn't play nice on our network. Could someone kick me into the right direction where to learn stuff like: function grabem(x integer) recordset ( grabem = select * from my_view where key = x )