See Below:
On 1 June 2010 16:28, John Gage <jsmgage(at)numericable(dot)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(at)postgresql(dot)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)