Hi Pat!
[My apologies if you get this more than once]
I've been looking at Roy Williams' comments. And pondering Latitude and Longitude functions. Have I misunderstood, and is there an unnecessary limitation? From the BNF:
<latitude> ::= LATITUDE <left_paren> <point> <right_paren>
and
<point> ::= POINT <left_paren> <coord_sys> <comma> <coordinates>
<right_paren>
POINT is a geometry expression. You cannot do:
select latitude( a.col1 ) from cata as a ;
Is this a problem?
Regards
Jeff
-- Jeff Lusted tel: +44 (0)116 252 3581 Astrogrid Project mob: +44 (0)7973 492290 Dept Physics & Astronomy email: jl99-at-star.le.ac.uk University of Leicester web: http://www.astrogrid.orgReceived on 2008-05-15Z16:25:28