Maciej Piekielniak <[EMAIL PROTECTED]> writes: > Is anybody know how create field in a new table with data type accuiring > from a field in other table?
Sorry, the %TYPE syntax only works in function declarations at the moment. It could possibly be made to work in table declarations --- there are syntactic conflicts with allowing it in general, but I'm not sure that objection applies to table declarations. But it's not there today. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend