147 reputation
15
bio website
location
age
visits member for 2 years, 7 months
seen Apr 28 at 13:19

Nov
15
awarded  Notable Question
Feb
11
awarded  Popular Question
Dec
5
comment Removing duplicate entries for each hour
Thank you! It finally works :)
Dec
5
accepted Removing duplicate entries for each hour
Dec
5
comment Removing duplicate entries for each hour
Now another problem is this: "table1.id" must appear in the GROUP BY clause or be used in an aggregate function
Dec
5
comment Removing duplicate entries for each hour
Already had that, but made it bold so it does not get overlooked ^^
Dec
5
revised Removing duplicate entries for each hour
added 9 characters in body
Dec
5
comment Removing duplicate entries for each hour
There is just one problem: "function max(uuid) does not exist". I already tried something like this...
Dec
5
asked Removing duplicate entries for each hour
Nov
3
awarded  Supporter
Nov
3
accepted How do I remove duplicate entries in a given timeframe?
Nov
3
comment How do I remove duplicate entries in a given timeframe?
Thank you very much :D
Nov
3
comment How do I remove duplicate entries in a given timeframe?
This is almost what i need, I should have been more specific about the timeframe :) Now, what I want to do is doing this for every hour within a day or a longer timeframe.
Nov
3
comment How do I remove duplicate entries in a given timeframe?
No, as the only difference between them is the timestamp and the precision needs to be only up to full hours.
Nov
3
awarded  Editor
Nov
3
revised How do I remove duplicate entries in a given timeframe?
Updated the table layout with the primary key.
Nov
3
comment How do I remove duplicate entries in a given timeframe?
Yeah I have an id, which ist the primary key. Also it is possible that there exist entries with the same value of row2.
Nov
3
asked How do I remove duplicate entries in a given timeframe?
Jan
11
awarded  Scholar
Jan
11
accepted Is there a simple way in PL/pgSQL to check if a query returned no result?