On Wed, Oct 22, 2003 at 12:50:22PM -0400, Darren Ferguson wrote: > create or replace function test() returns integer as ' > declare > _test timestamp with time zone; > _f integer; > begin > _test := current_timestamp; > _f := extract(epoch from timestamp _test);
Why not simply _f := extract(epoch from _test); ? > return _f; > end;' language 'plpgsql'; -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "Hay que recordar que la existencia en el cosmos, y particularmente la elaboración de civilizaciones dentre de él no son, por desgracia, nada idílicas" (Ijon Tichy) ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings