Postgres Pro
Downloads
Home   >   mailing lists

Re: Using case in an update statement ? - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Using case in an update statement ?
Date
Msg-id web-1499913@davinci.ethosmedia.com
Whole thread Raw
In response to Using case in an update statement ?  ("Peter Alberer" <peter@alberer.com>)
List pgsql-novice
Tree view 
Peter,

> update lr_object_usage set status = (case when status = ''OPEN_SUCC''
> then ''CLOSED_SUCC'' when status = ''OPEN_FAIL'' then
> ''CLOSED_FAIL'');

You're missing something:

update lr_object_usage set status = (case when status = ''OPEN_SUCC''
then ''CLOSED_SUCC'' when status = ''OPEN_FAIL'' then
''CLOSED_FAIL'' END);

FYI, in the future, please e-mail the error you get as well as your
question.  It helps us diagnose the problem.

-Josh Berkus

pgsql-novice by date:

Previous
From: "Peter Alberer"
Date:
Subject: Using case in an update statement ?
Next
From: Manfred Koizar
Date:
Subject: Re: Using case in an update statement ?