Hacker Newsnew | past | comments | ask | show | jobs | submit | Exuma's commentslogin


Turning off soap opera setting on every single person I visit... and watching their reaction ... "dude...... I've been arguing with my wife about this and she thinks im crazy!!!"


I love ruby so much


Which was the GTA where you rode around on a dirtbike out in the california mountains, and there was like bootleggers and stuff.... man i have serious memories of that game


ALL YOU HAD TO DO WAS FOLLOW THE DAMN TRAIN, CJ!


Dude............omg..............holy SHIT i forgot about that. NOOOOOOO!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


San Andreas


This is good stuff


Also just let me reference the damn alias in a group by, FUCK


At least in PostgreSQL, both by alias and ordinal are possible:

  localhost(from SCB-MUSE-BOXX).postgres.scb.5432 [Sun Nov 16 12:02:15 PST 2025]
  > create table test (a_key integer primary key, a_group integer, a_val numeric);
  CREATE TABLE
  Time: 3.102 ms

  localhost(from SCB-MUSE-BOXX).postgres.scb.5432 [Sun Nov 16 12:02:25 PST 2025]
  > insert into test (a_key, a_group, a_val) values (1, 1, 5.5), (2, 1, 2.6), (3, 2, 1.1), (4, 2, 6.5);
  INSERT 0 4
  Time: 2.302 ms

  localhost(from SCB-MUSE-BOXX).postgres.scb.5432 [Sun Nov 16 12:02:58 PST 2025]
  > select a_group AS my_group, sum(a_val) from test group by my_group;
   my_group | sum
  ----------+-----
          2 | 7.6
          1 | 8.1
  (2 rows)
  
  Time: 4.124 ms
  localhost(from SCB-MUSE-BOXX).postgres.scb.5432 [Sun Nov 16 12:03:15 PST 2025]
  > select a_group AS my_group, sum(a_val) from test group by 1;
   my_group | sum
  ----------+-----
          2 | 7.6
          1 | 8.1
  (2 rows)
  
  Time: 0.360 ms


Some do. It would also be nice to reference by ordinal number similar to order by. Very handy for quick and dirty queries. I can see the issue though that people start to lean on it too much.


The problem with this and similar requests is that it would change the identifier scoping in incompatible ways and therefore potentially break a lot of existing SQL code.


I think it should be not only in GROUP BY, but in every context, e.g., inside expressions in SELECT, WHERE, etc.


PostgreSQL and DuckDB support this, which makes MSSQL feel like a dinosaur in context.


I imagine it would be no different than current indexing strategies with a temporal aspect baked in... it would act almost like a different site, and maybe roll up the results after the fact by domain


No, I shall not "be worried." Unless you are some spineless blob of agencyless ooze... you should be able to parse reality in such a way that your day not need to be filled with worrying


i hate python, but the idea of replacing python with rust is absurd



I have 100 of these in the training data under not_fish....


This guy reddits


Moray fans in outrage.


> I built a basic CNN trained against penises and swastikas

From the description


I would say its a 100% dfish


First thing I drew.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: