pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / 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>
  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 20:37  Orion <o2@trustcommerce.com>
  parent: 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