Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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: Tue, 13 Jun 2006 19:19:33 -0400
  • Message-id: <000001c68f3f$d90198f0$1264a8c0(at)theport(dot)com>

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.




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group