Want to read Slashdot from your mobile device? Point it at m.slashdot.org and keep reading!

 


Forgot your password?
Close
typodupeerror
×
User Journal

Journal Tet's Journal: SQL isn't quite as braindead as I thought 2

Journal by Tet
Don't get me wrong, SQL is a hideous language that makes it hard to express common things, and impossible to express some more complex things. But today I learned about the coalesce() function, which makes it just that little bit more bearable.
This discussion has been archived. No new comments can be posted.

SQL isn't quite as braindead as I thought More

SQL isn't quite as braindead as I thought

Comments Filter:

  • but at coalesce() you're not even in it yet, much less finding out how far down it goes.

    Which DB are you using? If it's postgresql, call us when you discover DISTINCT ON () ;)

  • The biggest issue with SQL is training yourself to think in terms of set-based operations. So many of the complaints I have heard about how hard it is to do something in SQL revolve around this one, basic premise of the language. It took me several years to become comfortable enough with set-based processing, but now I am fully at ease with it and can do some things I thought were impossible when I was starting out with the language.

    It's kinda like approaching a functional programming language with a proced

Slashdot Top Deals

Any circuit design must contain at least one part which is obsolete, two parts which are unobtainable, and three parts which are still under development.

Close