On 11/02/10 09:06, Kevin Grittner wrote:
timestamp type in SQL Server is like ROWID in Oracle, and as Kevin said, you could use the serial type as a replacement.Luis Dominguez<[email protected]> wrote:I am now in the process of migrating a database from a driver ms sql server 7.0 to postgresql 8.4 vesion but I have a problem with the data type (timestamp) SQL Server 7.0 that refers to a single binary field that is updated randomly by row, and this field is paramount in my application for purposes of monitoring, postgresql 8.4 now also have the same timestamp but refers to other data (date + time), I investigated other types of data such as (serial, uuid, xid, byte etc) in postgresql and not get something just to replace it, I thought of a function that do something similar but not yet tried, and of course I turn to you to see if I can lend a hand with this rut that I have right nowDid you consider creating a SEQUENCE used by a trigger on update or insert of a row? http://www.postgresql.org/docs/8.4/interactive/sql-createsequence.html -Kevin -- TIP 1: para suscribirte y desuscribirte, visita http://archives.postgresql.org/pgsql-es-ayuda
-- ------------------------------------------------------------------------------------------- L.A. Jenaro Centeno Gómez Al-Día Se renueva con la mejora continua. Jefe de Tecnologías de la Información Alimentos La Concordia, S.A. de C.V. Tel. 01 474 741 9200 Ext. 9280 www.aldia.com.mx
<<attachment: jcenteno.vcf>>
--
TIP 6: ¿Has buscado en los archivos de nuestra lista de correo?
http://archives.postgresql.org/pgsql-es-ayuda
