On Wed, 9 Feb 2011 08:21:47 +1300 Andrej <andrej.gro...@gmail.com> wrote:
>On 9 February 2011 07:14, Tarlika Elisabeth Schmitz ><postgres...@numerixtechnology.de> wrote: >> From the date and time I want to create a timestamp. >> I know that >> - the events take place during the day, say between 10:30 and 22:30 >> - it's always a set of events at one location spaced about 30min >> apart >> - the imported data are chained (have a link to previous/next event) > >Any chance of seeing actual data? Might be a job for awk/perl rather >than the RDBMS. attached small CSV sample: at both locations, events start just after twelve o'clock (noon). -- Best Regards, Tarlika Elisabeth Schmitz
location_id datum otime id previous next 253 2010-09-08 01:05 942 941 943 253 2010-09-08 01:40 943 942 944 253 2010-09-08 02:10 944 943 945 253 2010-09-08 02:45 945 944 946 253 2010-09-08 03:20 946 945 947 253 2010-09-08 03:50 947 946 (null) 253 2010-09-08 12:30 941 (null) 942 9062 2010-09-08 01:00 858 857 859 9062 2010-09-08 01:35 859 858 860 9062 2010-09-08 02:05 860 859 861 9062 2010-09-08 02:40 861 860 862 9062 2010-09-08 03:15 862 861 863 9062 2010-09-08 03:45 863 862 (null) 9062 2010-09-08 12:25 857 (null) 858
-- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
