From: | "Chris Velevitch" <chris(dot)velevitch(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Problem with complex outer join expression |
Date: | 2006-04-26 06:25:04 |
Message-ID: | b0a3bf780604252325s31cbef5fy53053ada1bd1a11e@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm using 7.4.5 on win XP Pro SP1.
I'm getting:-
ERROR: syntax error at or near "(" at character 155
from the query:-
select dummy_records.sequence_nr,timesheets.weekending,timesheets.timesheet_id
from dummy_records
,left outer join timesheets
on (timesheets.weekending = ('2006-04-09' + (integer
dummy_records.sequence_nr-1)*7)))
where dummy_records.sequence_nr between 1 and (date '2006-04-23' -
date '2006-04-09')/7+1;
What this query is trying to achieve is:-
Find all weekending dates between 2 given weekending dates and any
corresponding timesheets for those weekending dates.
What am I doing wrong here? How do I achieve what I want?
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au
From | Date | Subject | |
---|---|---|---|
Next Message | IvoD | 2006-04-26 06:30:23 | Re: Database Selection |
Previous Message | IvoD | 2006-04-26 05:37:42 | Re: Database Selection |