> 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 tried this:
CREATE FUNCTION somefunc() RETURNS integer AS '
BEGIN
select count(colx) from anothertable;
END;
is it the right syntax?
also, how do I call my function as a default value, do I just need to "default
somefunc()" at the end of the column?
one more question, I couldn't find in the documentation how to dump databases
in a text file. could u give me the syntax?
thanx in advance