Skip site navigation (1) Skip section navigation (2)

re : Problem with UPDATE query

From: <pejac(at)altern(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: re : Problem with UPDATE query
Date: 2001-02-12 15:31:22
Message-ID: 200102121533.f1CFXVx14631@mail.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

You make a mistake in your update query . You must just write
one time set command.

Your Correct query is :
PDATE foo SET v2=3,v3=4 WHERE v1=1 ;

Cheers,

PEJAC Pascal

pgsql-novice by date

Next:From: Brett W. McCoyDate: 2001-02-12 15:36:37
Subject: Re: Problem with UPDATE query
Previous:From: pejacDate: 2001-02-12 15:14:33
Subject: re : UPDATES

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group