On Mon, 30 Jun 2003, Erik Erkelens wrote: > new_max_records ALIAS FOR $1; > BEGIN > DROP SEQUENCE my_sequence; > --CREATE SEQUENCE my_sequence MAXVALUE 4 > CYCLE; > CREATE SEQUENCE my_sequence MAXVALUE > new_max_records CYCLE;
Most of the creates/drops/etc... don't directly work with variables/arguments. You can probably do this with execute however. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend