Re: Putting an aggregate value in an UPDATE statement... - Mailing list pgsql-novice

From Bret Fledderjohn
Subject Re: Putting an aggregate value in an UPDATE statement...
Date
Msg-id AANLkTinI-mUlozkb3NuTT4OpmEymiQwVgrH-V0iUzDXz@mail.gmail.com
Whole thread Raw
In response to Putting an aggregate value in an UPDATE statement...  (John Gage <jsmgage@numericable.fr>)
Responses Re: Putting an aggregate value in an UPDATE statement...  (John Gage <jsmgage@numericable.fr>)
List pgsql-novice
See Below:

On 1 June 2010 16:28, John Gage <jsmgage@numericable.fr> wrote:
This statement:


UPDATE question_choices SET total_rows = count(*) from care_lesson

UPDATE question_choices SET total_rows = (select count(*) from care_lesson);



--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice



--

- Bret
____________________________________________
"Why should I fret in microcosmic bonds
That chafe the spirit, and the mind repress,
When through the clouds gleam beckoning beyonds
Where shining vistas mock man's littleness?"
- H.P. Lovecraft, "Phaeton" (1918)

pgsql-novice by date:

Previous
From: Mariateresa L
Date:
Subject: Re: sql files in psql ?
Next
From: Andrej
Date:
Subject: Re: Invitation to connect on LinkedIn