Re: [SQL] Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4

2006-09-15 Thread A. Kretschmer
am Fri, dem 15.09.2006, um 11:16:06 +0200 mailte [EMAIL PROTECTED] folgendes: > Is there some query optimization config setting I can set in pgsql 8.1.4 to > fix Yes. 'add_missing_from = true' in the postgresql.conf http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html But, you shou

Re: [SQL] Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4

2006-09-15 Thread Milen A. Radev
[EMAIL PROTECTED] написа: [...] > Is there some query optimization config setting I can set in pgsql 8.1.4 to > fix > this problem rather than having to change the queries in the code? I've read > over the changes between pgsql 7 and pgsql 8 but nothing seems to stand out to > me as referencing t

[SQL] Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4

2006-09-15 Thread gould
hi I am upgrading from pgsql 7.4.1 to pgsql 8.1.4. However, some of the application queries won't run on the newer version of pgsql. An example of the type of query is: SELECT protein_external_links.protein_id, external_links.external_id, proteins.public_name WHERE protein_external_links.external_