Re: update multiple columns

Duh!! My stupid! End of the day error I guess. Thanks for the help. I
shoulda known better :)
Julie
----- Original Message -----
From: "Michael Paesold" <mpaesold(at)gmx(dot)at>
To: <pgsql-novice(at)postgresql(dot)org>
Sent: Thursday, July 11, 2002 5:21 PM
Subject: Re: [NOVICE] update multiple columns

> "Juliet May" <jmay(at)speark(dot)com> wrote:
>
> > The comma gives me a parse error at or near "username". Without the
comma
> I
> > get a parse error at or near "set".
> >
> > Any other suggestions?
> >
> > ----- Original Message -----
> > From: "Oliver Kohll" <oliver(at)gtwebmarque(dot)com>
> > To: <pgsql-novice(at)postgresql(dot)org>
> > Sent: Thursday, July 11, 2002 6:15 PM
> > Subject: Re: [NOVICE] update multiple columns
> >
> >
> > UPDATE growernet_user
> > SET email='madegn(at)hotmail(dot)com', username='adegn'
> > WHERE user_id='696'
>
> Did you try this exact query?
>
> update growernet_user set email='madegn(at)hotmail(dot)com', username='adegn'
where
> user_id=696;
>
> only one "set"? only one comma between the two field=value pairs?
>
> Michael
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org