Hope someone's out there for this one. Basically I'm creating a summary table
of many
underlying tables in one select statement ( though that may have to change ).
My problem
can be shown in this example..
select my_function( timeofmeasurement, longitude ) as solarnoon,
extract(epoch
select my_function( timeofmeasurement, longitude ) as solarnoon,
extract(epoch from ( timeofmeasurement - solarnoon ) as solardiff
( case when solardiff 3600 then 'Y' else 'N' end ) as
within_solar_hour from
my_table;
But I get an error along the lines of
ERROR: column
On 11/07/2011 20:19, David Salisbury wrote:
Hope someone's out there for this one. Basically I'm creating a summary
table of many
underlying tables in one select statement ( though that may have to
change ). My problem
can be shown in this example..
select my_function( timeofmeasurement,