| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Rommel the iCeMAn" <icecrew(at)gmail(dot)com> |
| Cc: | "PostgreSQL SQL Mailing List" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Error with "limit" clause |
| Date: | 2006-06-14 01:58:13 |
| Message-ID: | 18723.1150250293@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
"Rommel the iCeMAn" <icecrew(at)gmail(dot)com> writes:
> 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?
Could VB be rewriting the query behind your back? Turn on log_statement
logging, and look in the postmaster log to see what's really being sent
to the backend ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Adan | 2006-06-14 02:30:02 | Good examples of calling slony stored procedures |
| Previous Message | Phillip Smith | 2006-06-14 00:51:08 | Re: COPY to table with array columns (Longish) |