BUG #4247: (Possible) SQL miscontruct not flagged

From: "J6M" <j6m(at)adm(dot)estp(dot)fr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4247: (Possible) SQL miscontruct not flagged
Date: 2008-06-17 17:13:20
Message-ID: 200806171713.m5HHDKJ5018306@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4247
Logged by: J6M
Email address: j6m(at)adm(dot)estp(dot)fr
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).

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-06-17 17:47:13 Re: BUG #4247: (Possible) SQL miscontruct not flagged
Previous Message Dave Page 2008-06-17 15:14:11 Re: BUG #4245: Product Name...