Martijn van Oosterhout <kleptog@xxxxxxxxx> writes: > If you just want to store numbers, use numeric. Why do you want to > combine numeric and a sequence? He could use a numeric column and write the default as nextval('seq')::numeric Of course, he'll be paying through the nose performance-wise for his insistence on not fixing his Oracle-centric data representation, but if programmer time is cheaper than machine time then maybe it's the right tradeoff. regards, tom lane