Error with "limit" clause

From: "Rommel the iCeMAn" <icecrew(at)gmail(dot)com>
To: "PostgreSQL SQL Mailing List" <pgsql-sql(at)postgresql(dot)org>
Subject: Error with "limit" clause
Date: 2006-06-13 23:19:33
Message-ID: 000001c68f3f$d90198f0$1264a8c0@theport.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Phillip Smith 2006-06-13 23:22:30 Re: COPY to table with array columns (Longish)
Previous Message Aaron Bono 2006-06-13 21:04:11 Re: Efficient Searching of Large Text Fields