Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: poll ideas quest 2012

by chacham (Vicar)
on Apr 19, 2012 at 23:58 UTC ( #966064=note: print w/ replies, xml ) Need Help??


in reply to poll ideas quest 2012

The (redundant) predicate in a SQL EXISTS() predicate should be "SELECT ?":

  • * -- Nothing says "i don't care" like a good asterisk
  • 1 -- "Everyone knows" asterisk causes a useless data dictionary lookup
  • '1' -- Characterizes a number one idea
  • NULL -- Why SELECT anything at all?
  • 'NULL' -- Null strings are best
  • '/dev/null' -- In case you nix the other ideas
  • 'NUL' -- Used in all Windows of opportunity
  • Avoid the issue by using IN() stead
  • Convolute the issue by doing a join


Comment on Re: poll ideas quest 2012

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://966064]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (7)
As of 2015-07-03 23:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (57 votes), past polls