Re: [SQL] Insert row in 1.10.1 and 1.10.3

2010-11-26 Thread ndias
You are both right, the Postgres version is 8.4, 1.10.3 is the pgAdmin version. Sorry the trouble, as you can see I am a newbie at Postgres. :) Best to all, Nuno Dias -- View this message in context: http://postgresql.1045698.n5.nabble.com/Insert-row-in-1-10-1-and-1-10-3-tp3281512p3281580.htm

Re: [SQL] Insert row in 1.10.1 and 1.10.3

2010-11-26 Thread ndias
Oliveiros, Thank you for your reply. I was debugging and printing the query also for myself and it was indeed something I was missing. The COM where the query is done was correct in number of values but the last field had a wrong value and was arriving there with a ',' in it, which caused the va

[SQL] Insert row in 1.10.1 and 1.10.3

2010-11-26 Thread ndias
Hello to all, I have a question regarding the behavior of insert row in the two versions, tried to search for it but could not find a similar case, please excuse if this has already been responded. When doing a insert row with less columns mentioned in "into table(col1, col2, col3,..." than the