X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9D2739DCDBD for ; Thu, 12 Jan 2006 11:48:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 65457-04 for ; Thu, 12 Jan 2006 11:48:19 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 8E5159DCD9A for ; Thu, 12 Jan 2006 11:48:12 -0400 (AST) Received: from mail.cognitronics.com (mail.cognitronics.com [198.151.128.252]) by svr4.postgresql.org (Postfix) with ESMTP id 3CF2C5AF027 for ; Thu, 12 Jan 2006 15:48:17 +0000 (GMT) Received: from [127.0.0.1] ([10.1.0.46]) by mail.cognitronics.com (8.13.0/8.13.0) with ESMTP id k0CFm1Y3035174 for ; Thu, 12 Jan 2006 10:48:03 -0500 (EST) Message-ID: <43C67A38.3070406@cognitronics.com> Date: Thu, 12 Jan 2006 10:48:08 -0500 From: Kashyap Jani User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-interfaces Subject: Getting data where select has a limit criteria Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200601/27 X-Sequence-Number: 5943 Hi, I am trying to issue a query like "SELECT * from limit 30". In psql command line interface it displays only 30 rows at a time. How will it behave if I use libpq. Is it going to return me only 30 rows ? Regards, Kashyap Jani