| From: | Doug McNaught <doug(at)mcnaught(dot)org> |
|---|---|
| To: | "Chris Travers" <chris(at)travelamericas(dot)com> |
| Cc: | "Chris Boget" <chris(at)wild(dot)net>, "PostgreSQL-general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Touch row ? |
| Date: | 2004-01-24 14:11:39 |
| Message-ID: | 878yjxxwpw.fsf@asmodeus.mcnaught.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce pgsql-general |
"Chris Travers" <chris(at)travelamericas(dot)com> writes:
>> Interesting. Yet another item to tack onto my list of differences between
>> MySQL and Postgres.
>
> Does MySQL apply defaults to updates?
Not quite. AIUI MySQL has a "magic timestamp" feature where the first
TIMESTAMP column in a table will be auto-stamped on insert and update
whether you like it or not. That's probably what the OP was
expecting.
-Doug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-01-24 17:18:53 | Re: Touch row ? |
| Previous Message | Eric B.Ridge | 2004-01-24 07:44:12 | Re: Touch row ? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marco Lazzeri | 2004-01-24 15:19:03 | Re: If table A value IS NULL then table B |
| Previous Message | Marco Lazzeri | 2004-01-24 14:07:43 | Re: If table A value IS NULL then table B |