7 Oct
2013
7 Oct
'13
3:13 p.m.
2) in other SQL databases you can often efficiently find out the column types of a query Q by running SELECT * FROM (Q) WHERE 0=1 is there a similar idiom for monetdb?
This is a valid empty query that will show the header (when the standard result format is selected), with data types, and no tuple. So yes, I guess this would give you what you want.
Except it doesn't, because monetdb doesn't supported limit/order by in subqueries...
3) where is a good place to read the ANSI SQL standards?
Easiest is to paste your exact question into the google box ;)
I have done that. But e.g. "ansi sql subquery order by" does not return any pointers to the spec. Hadley -- Chief Scientist, RStudio http://had.co.nz/