Received: from mail.utexas.edu (wb2-a.mail.utexas.edu [128.83.126.136]) by postgresql.org (8.11.3/8.11.4) with SMTP id f771Fj611060 for ; Mon, 6 Aug 2001 21:15:45 -0400 (EDT) (envelope-from webmaster@robbyslaughter.com) Received: (qmail 29626 invoked by uid 0); 7 Aug 2001 01:15:41 -0000 Received: from adsl-65-67-62-24.dsl.austtx.swbell.net (HELO robmanbox) (65.67.62.24) by umbs-smtp-2 with SMTP; 7 Aug 2001 01:15:41 -0000 Reply-To: From: "Robby Slaughter" To: "Gonzo Rock" , Subject: RE: Simple Insert Problem Date: Mon, 6 Aug 2001 20:17:46 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 In-Reply-To: <3.0.5.32.20010806171753.009ea5c0@postoffice.pacbell.net> Importance: Normal X-Archive-Number: 200108/80 X-Sequence-Number: 4301 Gonzo: You need to make sure that you delimit your values correctly. To insert text fields (which may contain spaces) use 'single quotes'. You'll also want to enter date fields the same way. So, you should try INSERT INTO OP (op_num,op_name,start_time) VALUES (5400,'Welding','06:00:00'); Of course, you're probably using the "time" data type, which means that 6:00:00 really means 6:00 in the morning! Hope that helps! -Robby -----Original Message----- From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Gonzo Rock Sent: Monday, August 06, 2001 7:18 PM To: pgsql-sql@postgresql.org Subject: [SQL] Simple Insert Problem 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, ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster