Don Patou <pknoob@noos.fr> writes:
> is it possible to have a query as a column default value.
Not directly, but you can fake it by hiding the query in an SQL or PL
function that you call in the DEFAULT expression.
I agree with the nearby replies questioning whether this is really what
you want to do at all ... but if it's, that's how.
regards, tom lane