Re: [SQL] Simple Insert Problem

2001-08-07 Thread Jan Wieck
[EMAIL PROTECTED] wrote: > Josh, > > Fuck you and the high horse you rode in on. Stop that language immediately! It is not accepted on any of our PostgreSQL mailing lists. > Yes as a matter of fact I did forget the quote marks. Do you think reading > that book will help with my silly sy

Re: [SQL] Simple Insert Problem

2001-08-06 Thread Josh Berkus
Gonzo, > F*** you and the high horse you rode in on. Please restrain yourself from posting strong language to the list. If you want to use stong language at me, please e-mail it directly. Further, I e-mailed an apology for touching a nerve, but you appear to have supplied an invalid reply-to

RE: [SQL] Simple Insert Problem

2001-08-06 Thread GonzoRock
Josh, Fuck you and the high horse you rode in on. Yes as a matter of fact I did forget the quote marks. Do you think reading that book will help with my silly syntactical errors? Do you think I did not pull my hair out prior to posting? Sometimes the obvious just eludes the smartest of us. Per

RE: [SQL] Simple Insert Problem

2001-08-06 Thread Robby Slaughter
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 c

Re: [SQL] Simple Insert Problem

2001-08-06 Thread Josh Berkus
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 >