i can't dodeclare vals default_vals%rowtype begin select get_defaults_vals() into vals; x1 := default_vals.a1;
try SELECT INTO vals * FROM get_defaults_vals() Pavel ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq