pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSimple Insert Problem
6+ messages / 5 participants
[nested] [flat]
* Simple Insert Problem
@ 2001-08-07 00:17 Gonzo Rock <GonzoRock@Excite.com>
2001-08-07 00:59 ` Re: Simple Insert Problem Josh Berkus <josh@agliodbs.com>
2001-08-07 01:17 ` RE: Simple Insert Problem Robby Slaughter <webmaster@robbyslaughter.com>
0 siblings, 2 replies; 6+ messages in thread
From: Gonzo Rock @ 2001-08-07 00:17 UTC (permalink / raw)
To: pgsql-sql
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,
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Simple Insert Problem
2001-08-07 00:17 Simple Insert Problem Gonzo Rock <GonzoRock@Excite.com>
@ 2001-08-07 00:59 ` Josh Berkus <josh@agliodbs.com>
1 sibling, 0 replies; 6+ messages in thread
From: Josh Berkus @ 2001-08-07 00:59 UTC (permalink / raw)
To: Gonzo Rock <GonzoRock@Excite.com>; 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 information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: Simple Insert Problem
2001-08-07 00:17 Simple Insert Problem Gonzo Rock <GonzoRock@Excite.com>
@ 2001-08-07 01:17 ` Robby Slaughter <webmaster@robbyslaughter.com>
1 sibling, 0 replies; 6+ messages in thread
From: Robby Slaughter @ 2001-08-07 01:17 UTC (permalink / raw)
To: Gonzo Rock <GonzoRock@Excite.com>; pgsql-sql
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: Simple Insert Problem
@ 2001-08-07 01:41 GonzoRock@excite.com
2001-08-07 01:57 ` Re: Simple Insert Problem Josh Berkus <josh@agliodbs.com>
2001-08-07 14:43 ` Re: Simple Insert Problem Jan Wieck <JanWieck@Yahoo.com>
0 siblings, 2 replies; 6+ messages in thread
From: GonzoRock@excite.com @ 2001-08-07 01:41 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; pgsql-sql
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.
Perhaps a better answer would have been:
Gonzo,
Maybe that question belongs in the pgsql-novice list instead. This list is
for the experts like myself.
Thanks, Josh
------------
Personally I think you are as Spiritually Bankrupt as that Silly website you
have been working on.
------------
later,
Gonzo
Oh and P.S. Thanks for the clue. I'm not spinning my wheels on that one
anymore, but I'm sure I'll run up aginst something else soon enough.
At 05:59 PM 8/6/01 -0700, you wrote:
>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 information technology josh@agliodbs.com
> and data management solutions (415) 565-7293
> for law firms, small businesses fax 621-2533
> and non-profit organizations. San Francisco
>
_______________________________________________________
Send a cool gift with your E-Card
http://www.bluemountain.com/giftcenter/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Simple Insert Problem
2001-08-07 01:41 RE: Simple Insert Problem GonzoRock@excite.com
@ 2001-08-07 01:57 ` Josh Berkus <josh@agliodbs.com>
1 sibling, 0 replies; 6+ messages in thread
From: Josh Berkus @ 2001-08-07 01:57 UTC (permalink / raw)
To: pgsql-sql
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 address -- thus forcing me to reply to
the list.
> Gonzo,
>
> Maybe that question belongs in the pgsql-novice list instead. This
> list is
> for the experts like myself.
Hey, you're right. I'll use something similar to that reply next time.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Simple Insert Problem
2001-08-07 01:41 RE: Simple Insert Problem GonzoRock@excite.com
@ 2001-08-07 14:43 ` Jan Wieck <JanWieck@Yahoo.com>
1 sibling, 0 replies; 6+ messages in thread
From: Jan Wieck @ 2001-08-07 14:43 UTC (permalink / raw)
To: GonzoRock@excite.com; +Cc: Josh Berkus <josh@agliodbs.com>; pgsql-sql
GonzoRock@excite.com 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 syntactical errors? Do you think I did not
> pull my hair out prior to posting? Sometimes the obvious just eludes the
> smartest of us.
All Josh did was to put the IMNSHO appropriate "Read The Fine
Manual" into polite words. And I don't see a problem with
that. Maybe reading that book might help you. Maybe reading
any book about SQL might help you. I guess somehow Josh got
the impression you haven't tried that yet.
> Oh and P.S. Thanks for the clue. I'm not spinning my wheels on that one
> anymore, but I'm sure I'll run up aginst something else soon enough.
Feel free to do so and be sure that you'll get the answer
(maybe with some tips where to gather that information
yourself :-). But stay calm and show the same amount of
tolerance you want to get.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2001-08-07 14:43 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-08-07 00:17 Simple Insert Problem Gonzo Rock <GonzoRock@Excite.com>
2001-08-07 00:59 ` Josh Berkus <josh@agliodbs.com>
2001-08-07 01:17 ` Robby Slaughter <webmaster@robbyslaughter.com>
2001-08-07 01:41 RE: Simple Insert Problem GonzoRock@excite.com
2001-08-07 01:57 ` Josh Berkus <josh@agliodbs.com>
2001-08-07 14:43 ` Jan Wieck <JanWieck@Yahoo.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