From: Rommel the iCeMAn <icecrew@gmail.com>
To: PostgreSQL SQL Mailing List <pgsql-sql@postgresql.org>
Subject: Error with "limit" clause
Date: Tue, 13 Jun 2006 19:19:33 -0400
Message-ID: <000001c68f3f$d90198f0$1264a8c0@theport.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: icecrew@gmail.com
Subject: Re: Error with "limit" clause
In-Reply-To: <000001c68f3f$d90198f0$1264a8c0@theport.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox