I probably discovered America… but this is very LISP-like 
WITH T1 as ( SELECT SNO AS SA, CITY FROM S ) ,
T2 as ( SELECT SNO AS SB, CITY FROM S ) ,
T3 as ( SELECT * from T1 NATURAL JOIN T2 ) ,
T4 AS ( SELECT * FROM T3 WHERE SA < SB )
SELECT SA, SB FROM T4
This is what you get from reading CISP and ‘SQL and Relational theory‘ in a row.
PS
Dreamed about newbie installing Linux on himself and attracting zillions of nuclear cyber-cooties. The moral was : always use Windows!
ESRI Dev Summit is much quieter than ESRI UC, for obvious reason of lower count of attendees. It’s usually held in Palm Springs Convention Center.
Palm Springs CC was most likely (forgive me for not checking Wikipedia) built during the shiny days of city’s glory, when all Hollywood hotshots loved to spend their weekends here. The style is unmistakable. Now about the favorite topic of every convention crasher – free food. Free food was in abundance. I was there only for one day (Wed Mar 24 2010), for that day ESRI provided free boxed lunch, drinks and snacks before and after lunch and free dinner (including beer and wine) on Dev Summit Attendee party. Beer was from Hangar 24, my favorite local brewery, and food was definitely of acceptable quality.
I attended several sessions presented by my colleagues, also had a good deal of talks in exhibit hall. (Exhibit hall is so small cozy that notion of ‘islands’ was close to non-existence, let’s just say I was there for significant chunk of my day).
Dev Summit is like boot camp for developers who want to get a glimpse of ArcGIS 10 early. Pre-release will be available soon and there’s plenty of other related activity happening – dev APIs are getting public as well. Continue reading ‘ESRI Dev Summit – musings’ »