pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gonzo Rock <GonzoRock@Excite.com>
To: pgsql-sql@postgresql.org
Subject: Simple Insert Problem
Date: Mon, 06 Aug 2001 17:17:53 -0700
Message-ID: <3.0.5.32.20010806171753.009ea5c0@postoffice.pacbell.net> (raw)

Sorry but this is making me crazy... yes... I'm way new to SQL



Why would this error out ??

This is the Query... 
INSERT INTO OP (op_num,op_name,start_time) Values (5400,Welding,06:00:00);

And this is the pgSQL error...
ERROR:  parser: parse error at or near ":"


The table has reasonable values in it already... I'm just adding a few more rows by hand.

Thanks All,




view thread (6+ messages)  latest in thread

Message-ID: <3.0.5.32.20010806171753.009ea5c0@postoffice.pacbell.net>
Permalink:  ../3.0.5.32.20010806171753.009ea5c0@postoffice.pacbell.net/
Also on:    postgresql.org/message-id/3.0.5.32.20010806171753.009ea5c0@postoffice.pacbell.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: GonzoRock@Excite.com
  Subject: Re: Simple Insert Problem
  In-Reply-To: <3.0.5.32.20010806171753.009ea5c0@postoffice.pacbell.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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