Error with "limit" clause

Поиск
Список
Период
Сортировка
От Rommel the iCeMAn
Тема Error with "limit" clause
Дата
Msg-id 000001c68f3f$d90198f0$1264a8c0@theport.com
обсуждение исходный текст
Ответы Re: Error with "limit" clause  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.



В списке pgsql-sql по дате отправления:

Предыдущее
От: "Aaron Bono"
Дата:
Сообщение: Re: Efficient Searching of Large Text Fields
Следующее
От: "Phillip Smith"
Дата:
Сообщение: Re: COPY to table with array columns (Longish)