-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Gregory Stark a écrit : > "Stéphane A. Schildknecht" <stephane.schildkne...@postgresqlfr.org> writes: (...) > > You could order by age(xmin) instead > >> What would be the best way to get last modified rows? > > I'm not sure using xmin is such a great idea really. It's handy for ad-hoc > queries but there are all kinds of cases where it might not give you the > results you expect. > > You probably want to put a timestamp column on your tables and manage the date > you put in their according to a policy you control. > >
Gregory, Thanks for the answer. A timestamp would surely be a better idea. BTW, I don't have hand on the schema yet and was just looking for a quick way to get some last modified rows. Regards, - -- Stéphane Schildknecht PostgreSQLFr - http://www.postgresql.fr Dalibo - http://www.dalibo.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJpV6qA+REPKWGI0ERAhq/AJwNt845SDujYmFhe4aTqI30QBBC9gCg4vcH edlSZti3KDtozJ82Od0nErQ= =z1lm -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
