[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_id, r.r_registration, r.r_chassis, r.r_vehicle, r.r_fuel, r.r_pack_mats, r.r_delivery,

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

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.r_chassis,

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

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

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. That

[SQL] Speed up slow select - was gone blind

Hi folks. I've got my select working now, but I haven't received the speed increase I'd expected. It replaced an earlier select which combined a single explicit join with multiple froms. The first select is the old one, the second one is the new one (with a new join). The new one takes

Re: [SQL] Speed up slow select - was gone blind

Can you send the EXPLAIN ANALYZE of each? We can't really tell where the slowdown is without that. On Apr 1, 2005 12:32 PM, Gary Stainburn [EMAIL PROTECTED] wrote: Hi folks. I've got my select working now, but I haven't received the speed increase I'd expected. It replaced an earlier

Re: [SQL] Speed up slow select - was gone blind

Try with creating INDEX on the used tables...It will make your search query faster. Thanks Dinesh Pandey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gary Stainburn Sent: Friday, April 01, 2005 6:03 PM To: pgsql-sql@postgresql.org Subject: [SQL]

[SQL] Order of items in FROM causes error?

A colleague has the following query, which errors with: relation dl does not exist. (See the second item in the FROM clause.) If that item is moved to immediately precede the first JOIN item however, the query works as expected. select u.usersfirstname || ' ' || u.userslastname as

Re: [SQL] Order of items in FROM causes error?

On Fri, 1 Apr 2005, Rosser Schwarz wrote: A colleague has the following query, which errors with: relation dl does not exist. (See the second item in the FROM clause.) If that item is moved to immediately precede the first JOIN item however, the query works as expected. select

Re: [SQL] Order of items in FROM causes error?

Rosser Schwarz [EMAIL PROTECTED] writes: A colleague has the following query, which errors with: relation dl does not exist. (See the second item in the FROM clause.) If that item is moved to immediately precede the first JOIN item however, the query works as expected. select