The following bug has been logged online: Bug reference: 4247 Logged by: J6M Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.13 Operating system: Linux x86-64 Description: (Possible) SQL miscontruct not flagged Details:
Hi, This European afternoon, I was trying to count how many distinct values of a row in a table exists and put this result in another table. Instead of writing : select distinct(ean13),(select count(*) from fiart where ean13=a.ean13) as n into zz from fiart as a ; I wrote : select distinct(ean13),(select count(*) into zz from fiart where ean13=a.ean13) as n from fiart as a ; I am not an expert in the most intricate shades of the SQL language. Should the SQL interpreter not flag the query as a misconstruct statement and fire an ERROR (or at least a WARNING) message ? (I'd guess it should). -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
