Don,
> is it possible to have a query as a column default value. I have a statistic
> table and I would like one of its column to do like "select count(colx) from
> anothertable".
> What's the best way to do this?
Add a Trigger to the table. See Triggers in the online docs, and also under
the PL/pgSQL docs (under "Procedural Languages").
--
-Josh Berkus
Aglio Database Solutions
San Francisco