Don Patou <pknoob(at)noos(dot)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