Re: Simple Insert Problem - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Simple Insert Problem
Date
Msg-id web-97748@davinci.ethosmedia.com
Whole thread Raw
In response to Simple Insert Problem  (Gonzo Rock <GonzoRock@Excite.com>)
List pgsql-sql
Gonzo,

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

Buy PostgreSQL: Introduction and Concepts.  Now.  Read it cover to cover
before posting any more questions, ok?


> Why would this error out ??
> 
> This is the Query... 
> INSERT INTO OP (op_num,op_name,start_time) Values
> (5400,Welding,06:00:00);

Because you've forgotten the quote marks.

-Josh Berkus


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


pgsql-sql by date:

Previous
From: Gonzo Rock
Date:
Subject: Simple Insert Problem
Next
From: "Robby Slaughter"
Date:
Subject: RE: Simple Insert Problem