pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Simple Insert Problem
6+ messages / 5 participants
[nested] [flat]

* Simple Insert Problem
@ 2001-08-07 00:17  Gonzo Rock <GonzoRock@Excite.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:59  Josh Berkus <josh@agliodbs.com>
  parent: Gonzo Rock <GonzoRock@Excite.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 01:17  Robby Slaughter <webmaster@robbyslaughter.com>
  parent: Gonzo Rock <GonzoRock@Excite.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
  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:57  Josh Berkus <josh@agliodbs.com>
  parent: GonzoRock@excite.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 14:43  Jan Wieck <JanWieck@Yahoo.com>
  parent: GonzoRock@excite.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