You are viewing a single thread.
View all comments View context
21 points

Why would there be an age and my_age column on the table GIRLS?

permalink
report
parent
reply
8 points

Because for each girl you meet, you might tell her a different age.

permalink
report
parent
reply
2 points

Ah, but if we care at all about normalization and that’s calculatable from the other columns (it should be) then it shouldn’t be a column. Unless it’s expensive and this is a view, of course.

permalink
report
parent
reply
15 points

Good point.

Should be age > (@my_age / 2) +7

FTFOP - now my age is some value defined outside the immediate query.

More likely, the GIRLS would be a view of some table persons and you could query my_age from that table too.

permalink
report
parent
reply
-1 points
*

Thank you. I assumed the reader would be educated enough to guess I meant a variable. But yeah, should used @my_age

permalink
report
parent
reply
3 points

Pretty sure “People who know enough about SQL to know about variables” is a subset of “People who know enough about SQL to be pedantic about it” :p

permalink
report
parent
reply

LinkedinLunatics

!linkedinlunatics@sh.itjust.works

Create post

A place to post ridiculous posts from linkedIn.com

(Full transparency… a mod for this sub happens to work there… but that doesn’t influence his moderation or laughter at a lot of posts.)

Community stats

  • 1.5K

    Monthly active users

  • 85

    Posts

  • 1.9K

    Comments

Community moderators