Re: [SQL] gone blind - can't see syntax error

2005-04-01 Thread Gary Stainburn
On Friday 01 April 2005 1:01 pm, you wrote: > On Friday 01 Apr 2005 5:06 pm, Gary Stainburn wrote: > > Hi folks. > > > > I've been looking at this for 10 minutes and can't see what's > > wrong. Anyone care to enlighten me. > > comma after 'r'? I'd only just added that comma, to try to fix it. Tha

Re: [SQL] gone blind - can't see syntax error

2005-04-01 Thread Kenneth Gonsalves
On Friday 01 Apr 2005 5:06 pm, Gary Stainburn wrote: > Hi folks. > > I've been looking at this for 10 minutes and can't see what's > wrong. Anyone care to enlighten me. comma after 'r'? -- regards kg http://www.livejournal.com/users/lawgon tally ho! http://avsap.sourceforge.net àà à!

Re: [SQL] gone blind - can't see syntax error

2005-04-01 Thread Mike Rylander
On Apr 1, 2005 11:36 AM, Gary Stainburn <[EMAIL PROTECTED]> wrote: > Hi folks. > > I've been looking at this for 10 minutes and can't see what's wrong. > Anyone care to enlighten me. > > Thanks > > Gary > > [EMAIL PROTECTED] webroot]# psql -a -f new-view.sql > SELECT r.r_id, r.r_registration, r

Re: [SQL] gone blind - can't see syntax error

2005-04-01 Thread Dinesh Pandey
:06 PM To: pgsql-sql@postgresql.org Subject: [SQL] gone blind - can't see syntax error Hi folks. I've been looking at this for 10 minutes and can't see what's wrong. Anyone care to enlighten me. Thanks Gary [EMAIL PROTECTED] webroot]# psql -a -f new-view.sql SELECT r.r_

[SQL] gone blind - can't see syntax error

2005-04-01 Thread Gary Stainburn
Hi folks. I've been looking at this for 10 minutes and can't see what's wrong. Anyone care to enlighten me. Thanks Gary [EMAIL PROTECTED] webroot]# psql -a -f new-view.sql SELECT r.r_id, r.r_registration, r.r_chassis, r.r_vehicle, r.r_fuel, r.r_pack_mats, r.r_delivery, (date(r.r_deli