El Martes, 19 de Enero de 2010, Iñaki Baz Castillo escribió:
> Hi, I need two columns in tables of MySQL/Postgres:
>
> - "created" (timestamp/datetime)
> - "last_modified" (timestamp/datetime)
>
> I want to avoid doing it with Ruby ("table[:created] = Time.now" and so) as
> I expect it's much faster if we let this job for the database itself.
>
> How could I tell Sequel to create a column datetime column with default
> value "NOW()"? Of course the following doesn't work:
>
> column :modified, DateTime, :default => "NOW()"
>
> Also I need it working for MySQL and Postgres.
Unfortunatelly I've realized that "ON UPDATE" doesn't work "out of the box" in
Postgres, instead creating a trigger is required:
http://stackoverflow.com/questions/1035980/postgresql-update-timestamp-when-
row-is-updated
--
Iñaki Baz Castillo <[email protected]>
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
