TAP RFC [MTIME]

[Gerard]

I agree with Pat and Francois, MTIME can be covered using standard DB
implementations, no need for a special key word. Extrapolating on Francois'
comment, I would propose to remove the "primary" attribute from the column
metadata? When I do a 

select * from SomeTable

I expect all the columns in the table to be returned. if I want fewer I do
aan explicit select.
If a TAP implementor wants to define some preferred sub-selection of the
columns this can be easily done using a VIEW.

What I think is missing from the column metadata is a "rank" attribute.
This would govern the order in which columns are returned when doing a 

select * from SomeTable

I don't remember this being discussed, can we still do this?

Cheers

Gerard

PS
Sorry for late entry to the discussions.


> 
> I fully agree with this Pat -- as mentioned several times, 
> having 'hidden' columns which may or may not exist is 
> inconsistent; my proposal was to have an explicit definition 
> in the TAP_SCHEMA which would define the actual column(s) 
> containing the time stamps necessary for this kind of 
> definition. And similarly time stamps should be added in the 
> TAP_SCHEMA.tables (dates of last modifications of tables).
> 
> --Francois
> 
> >
> >On Monday 14 September 2009 02:00:09 Keith Noddle wrote:
> >> TAP RFC to 25th September to allow the above details to 
> come together.
> >
> >It turns out that combining MTIME with ADQL is do-able but 
> can be quite 
> >complex. Describing exactly how it should work in enough detail that 
> >people will implement it and use it consistently and correctly is 
> >beyond what I think we can accomplish in the remaining days 
> of the RFC period.
> >
> >Therefore, I propose to drop MTIME from TAP 1.0 and we can discuss 
> >whether to add it to TAP 1.x or PQL later on.
> >
> >--
> >
> >Patrick Dowler
> >Tel/Tl: (250) 363-0044
> >Canadian Astronomy Data Centre
> >National Research Council Canada
> >5071 West Saanich Road
> >Victoria, BC V9E 2M7
> >
> >Centre canadien de donnees astronomiques Conseil national de 
> recherches 
> >Canada 5071, chemin West Saanich Victoria (C.-B.) V9E 2M7
> ==============================================================
> =========
> Francois Ochsenbein    ------   Observatoire Astronomique de 
> Strasbourg
>    11, rue de l'Universite 67000 STRASBOURG  Phone: 
> +33-(0)368 85 24 29
> Email: francois at astro.u-strasbg.fr (France)    Fax: 
> +33-(0)368 85 24 17
> ==============================================================
> =========
>