Re: [SQL] Error with "limit" clause

2006-06-13 Thread Rommel the iCeMAn
> 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 ... Exactly! This was an oversight on my part tho. I had used the following command: MyDataReader = MyCommand.ExecuteReader(CommandB

Re: [SQL] Error with "limit" clause

2006-06-13 Thread Tom Lane
"Rommel the iCeMAn" <[EMAIL PROTECTED]> 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

[SQL] Error with "limit" clause

2006-06-13 Thread Rommel the iCeMAn
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 caus