Re: How should I phrase this?
От | Mitch Vincent |
---|---|
Тема | Re: How should I phrase this? |
Дата | |
Msg-id | 000c01c107da$6d28f430$1251000a@Mitch обсуждение исходный текст |
Ответ на | How should I phrase this? (Paul Tomblin <ptomblin@xcski.com>) |
Ответы |
Re: How should I phrase this?
|
Список | pgsql-general |
An alternative, though I'm not sure it's better in any way : DELETE FROM generators WHERE started + '30 minutes'::interval <= now(); -Mitch ----- Original Message ----- From: "Paul Tomblin" <ptomblin@xcski.com> To: <pgsql-general@postgresql.org> Sent: Sunday, July 08, 2001 2:12 PM Subject: [GENERAL] How should I phrase this? > I've got a table that I insert a value and a timestamp "now()". Then I > want to delete entries that are older than 30 minutes old. After some > experimentation, I found the following works, but it looks awkward and > backwards. Is there a better, more readable way of phrasing this or > rewriting it? > > DELETE > FROM generators > WHERE age(now(),started) > interval '30 minutes' > > > -- > Paul Tomblin <ptomblin@xcski.com>, not speaking for anybody > "Nobody can be told what the dominatrix is, they have to see it for themselves" > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >
В списке pgsql-general по дате отправления: