Re: [SQL] Insert row in 1.10.1 and 1.10.3

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

Le 26/11/2010 18:14, Thomas Kellerer a écrit : > ndias, 26.11.2010 17:22: >> When doing a insert row with less columns mentioned in "into table(col1, >> col2, col3,..." than the columns that exist on the table, on 1.10.1 it >> returns an error saying "INSERT has more expressions than target columns

Re: [SQL] Insert row in 1.10.1 and 1.10.3

ndias, 26.11.2010 17:22: When doing a insert row with less columns mentioned in "into table(col1, col2, col3,..." than the columns that exist on the table, on 1.10.1 it returns an error saying "INSERT has more expressions than target columns" (the error is translated so maybe the text is not exac

Re: [SQL] Insert row in 1.10.1 and 1.10.3

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

Re: [SQL] Insert row in 1.10.1 and 1.10.3

Could you please include the full insert SQL statement? Best, Oliveiros - Original Message - From: "ndias" To: Sent: Friday, November 26, 2010 4:22 PM Subject: [SQL] Insert row in 1.10.1 and 1.10.3 Hello to all, I have a question regarding the behavior of insert row in the two

Re: [SQL] group by hour + distinct

Michele Petrazzo - Unipex wrote: P.s. Have you some references about the "subquery" keyword? I found only the word subquery as "use" (for example: select a from b where id in (select id from table)), but not as sql [sic] command. "subquery" is not an SQL keyword.

[SQL] Insert row in 1.10.1 and 1.10.3

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

Re: [SQL] group by hour + distinct

Ciao * Olá! for each hour it will count the number of distinct user_id's there are . If I understood correctly what you need... Can you please test it and see if it is OK for your needs? With me, it worked on the sample data you provided Yes! Simply perfect! * Great to hear it worked

Re: [SQL] group by hour + distinct

Oliveiros d'Azevedo Cristina ha scritto: Howdy, Michelle, Ciao for each hour it will count the number of distinct user_id's there are . If I understood correctly what you need... Can you please test it and see if it is OK for your needs? With me, it worked on the sample data you provided

Re: [SQL] group by hour + distinct

Howdy, Michelle, If you write something like this, SELECT hour , COUNT(id_user) as count FROM ( SELECT EXTRACT(hour from my_date) as hour, id_user FROM michelle GROUP BY EXTRACT(hour from my_date),id_user )subquery GROUP BY hour for each hour it will count the number of distinct user_id's ther

[SQL] group by hour + distinct

Hi list, Into a table like this: id_user | my_date and some data inside 1 | 2010/11/25 00:01:00 1 | 2010/11/25 00:02:00 1 | 2010/11/25 01:01:00 2 | 2010/11/25 02:01:00 3 | 2010/11/25 02:01:00 3 | 2010/11/25 02:06:00 1 | 2010/11/25 03:01:00 I'm looking for a query that say me, hour per hour, how