Re: syntax error

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 22 Jun 2006 11:46:52 GMT
Message-ID: <1150976811.192838@proxy.dienste.wien.at>

Karsten Schenk <karsten-schenk_at_gmx.net> wrote:
> I 'm a beginner and I have following question:
> Something seems to be wrong with the syntax of these lines.
> It must be something tiny.
> Can anyone help me?
>
> EXECUTE IMMEDIATE 'SELECT COUNT(*) - COUNT ('|| c || ') AS nulls,
> COUNT(DISTINCT ' || c || ') AS different , COUNT ('||c||') AS total'
> FROM ' || t INTO nulls, different, total;
> EXECUTE IMMEDIATE 'INSERT INTO ' || dest || ' (id, nulls, different,
> total) VALUES ( :1, :2, :3, :4)' USING (id, nulls, different, total);

Sure, an apostrophe is a tiny character...

You seem to distribute the apostrophes quite randomly across your statements - the first statement has 9 of them, if I count right.

Yours,
Laurenz Albe Received on Thu Jun 22 2006 - 06:46:52 CDT