pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Funny Parse Error on Insert 2+ messages / 1 participants [nested] [flat]
* Funny Parse Error on Insert @ 2001-11-12 19:12 Orion <o2@trustcommerce.com> 2001-11-12 20:37 ` Re: Funny Parse Error on Insert Orion <o2@trustcommerce.com> 0 siblings, 1 reply; 2+ messages in thread From: Orion @ 2001-11-12 19:12 UTC (permalink / raw) To: pgsql-sql I am getting a parse error on insert and I cant tell why. Anyone better at SQL what to lend me a hand? I'm just doing a simple 'INSERT INTO table (x,y) SELECT ...' Here's my statement and the error. fdb=> INSERT INTO mfps_action_codes_394 (code,description) SELECT '$','Dun Notice Printed' WHERE NOT EXISTS (SELECT 1 FROM mfps_action_codes_394 WERE code = '$'); ERROR: parser: parse error at or near "code" Note if I remove the WHERE clause from the SELECT it works... fdb=> INSERT INTO mfps_action_codes_394 (code,description) SELECT '$','Dun Notice Printed'; INSERT 9751582 1 Why would this happen? ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Funny Parse Error on Insert 2001-11-12 19:12 Funny Parse Error on Insert Orion <o2@trustcommerce.com> @ 2001-11-12 20:37 ` Orion <o2@trustcommerce.com> 0 siblings, 0 replies; 2+ messages in thread From: Orion @ 2001-11-12 20:37 UTC (permalink / raw) To: pgsql-sql Please ignore. I cant spell WHERE :( ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-11-12 20:37 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2001-11-12 19:12 Funny Parse Error on Insert Orion <o2@trustcommerce.com> 2001-11-12 20:37 ` Orion <o2@trustcommerce.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox