X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id EFEE29FA38F for ; Tue, 13 Jun 2006 20:21:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 46204-01 for ; Tue, 13 Jun 2006 20:21:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.238]) by postgresql.org (Postfix) with ESMTP id A7CE59FA1A8 for ; Tue, 13 Jun 2006 20:21:26 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 58so271957wri for ; Tue, 13 Jun 2006 16:21:25 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:from:to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:x-mimeole; b=SH/oBwKHK8m+yVGdH6yTMoRaYRzMU2adbRnFQX1NzZSSnCn98Nj0yHSxkpchzIeU0c+HNFuZ1iadkg+ltBdxaJ9UVUjuG3TyeGgpzM8W2po+N7L1lI0ceBQqhtK42xLFaWzoLFI+75FSagYmNW2kmj3ct76ZiQdipK2sTeU/C3M= Received: by 10.54.110.8 with SMTP id i8mr5079wrc; Tue, 13 Jun 2006 16:21:25 -0700 (PDT) Received: from mis06 ( [205.214.220.146]) by mx.gmail.com with ESMTP id 9sm5995075wrl.2006.06.13.16.21.23; Tue, 13 Jun 2006 16:21:24 -0700 (PDT) From: "Rommel the iCeMAn" To: "PostgreSQL SQL Mailing List" Subject: Error with "limit" clause Date: Tue, 13 Jun 2006 19:19:33 -0400 Message-ID: <000001c68f3f$d90198f0$1264a8c0@theport.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 Thread-Index: AcaPPjrQX+viNNcGSlGNczybdBJrpA== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/140 X-Sequence-Number: 25376 Hi List, I've been trying the following query from VB.NET: select * from my_table order by column1 limit 1. This query works flawlessly when I use the pgAdminIII query tool, but when I run this query from VB.NET, I get the following error: syntax error at or near "limit". Any ideas as to the cause of this error? Seems to me this error is specific to the PostgreSQL .NET providers, what do you think? If it's of any help, here's my connection string: database=test;User ID=iceman;Password={suppressed};Server=my_server;Port=5432;Timeout=10 Thanks in advance, Rommel Edwards.