Martijn van Oosterhout <kleptog@svana.org> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings