Yeah your right Alban, that looks bad, but it was an artifact of
'try-this, try-this, no, try-this'.
The table is empty, and unfortunately remains that way; nothing gets
inserted.
I tried other variations, however FOUND just isn't behaving as I would
think.
-----------------------------------------------
OUTPUT SNIPPET:
NOTICE: SQL cmd is = SELECT COUNT(*) FROM zbus_tokens WHERE token = PARKING
NOTICE: Row = 10, Skipped INSERT Count = 32, Word2 = PARING
NOTICE: SQL cmd is = SELECT COUNT(*) FROM zbus_tokens WHERE token = COLLEEN
NOTICE: Row = 11, Skipped INSERT Count = 33, Word2 = COLLEEN
-----------------------------------------------
Alban Hertroys wrote:
On 9 Nov 2010, at 5:11, Ralph Smith wrote:
Why is FOUND 'finding' and hence avoiding an INSERT?
Not really sure what your point is (don't have time to look
closely), but...
PERFORM Rnotice1(1,''SQL cmd is'',''SELECT COUNT(*) FROM
zbus_tokens WHERE token = ''||Word2::varchar) ;
PERFORM (SELECT COUNT(*) FROM zbus_tokens WHERE token = Word2) ;
IF NOT FOUND THEN
PERFORM RNotice1(1,''value'',Word2) ;
INSERT INTO zbus_tokens (token) values(Word2);
J=J+1 ;
IF J % 100 = 0 THEN
PERFORM Rnotice2(1,''Row'',I,''Insert Count'',J) ;
END IF ;
ELSE
K=K+1 ;
PERFORM RNotice2(1,''Row'',I,''Skipped INSERT Count'',K) ;
END IF ;
You just connected this ELSE block to the IF statement it was nested
inside.
You probably need to comment out the rest of this ELSE block as well.
Alban Hertroys
--
Screwing up is an excellent way to attach something to the ceiling.
(Assuming you're not turning the screw driver the wrong way.)
--
Ralph
_________________________
--
Ralph
_________________________
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
