197 reputation
210
bio website boob.pocebo.sk
location Bratislava, Slovakia
age 28
visits member for 1 year, 11 months
seen Jul 4 at 7:34

nothing special about me :)


Oct
14
awarded  Notable Question
Sep
23
awarded  Notable Question
Jul
2
awarded  Curious
Jun
4
awarded  Popular Question
Dec
20
awarded  Popular Question
Nov
16
awarded  Popular Question
Apr
17
revised PostgreSQL stored procedure to return rows or empty set
added 87 characters in body
Apr
17
awarded  Tumbleweed
Apr
17
revised PostgreSQL stored procedure to return rows or empty set
added 265 characters in body
Apr
17
asked PostgreSQL stored procedure to return rows or empty set
Apr
16
asked PostgreSQL stored procedure which can return one of two custom rowtypes
Apr
10
accepted Find “n” consecutive free numbers from table
Mar
22
awarded  Supporter
Mar
19
comment Find “n” consecutive free numbers from table
this looks fine without window functions, but it returns all the "last numbers" for all possibilities (sqlfiddle.com/#!12/13127/10), so for n=3 it returns just 000010 (i wanted to return all free numbers for this group, so it would be 000008, 000009, 000010.. and i'd like to have only first possible group)
Mar
19
revised Find “n” consecutive free numbers from table
added 25 characters in body
Mar
18
comment Find “n” consecutive free numbers from table
I edited my question (after wanted return), it will be executed only for one id_set, so only first possible group found
Mar
18
revised Find “n” consecutive free numbers from table
added 119 characters in body; edited tags
Mar
18
comment Find “n” consecutive free numbers from table
Yes, the numbers in one set are unique and consective from 000 to 999 without any gaps, I don't have time to try this, I will try it tomorrow, thanks very much to all of you for now :)
Mar
18
comment Find “n” consecutive free numbers from table
Thank you very much, this looks nice, but it's possible to change it so only first group of numbers is returned? If I change it to cnt >= 2, then I get 5 numbers (2 groups = 2 + 3 numbers)
Mar
18
awarded  Editor