Re: newbie sql question: select every day another quote
От | Janning Vygen |
---|---|
Тема | Re: newbie sql question: select every day another quote |
Дата | |
Msg-id | 01051215014903.29826@janning обсуждение исходный текст |
Ответ на | newbie sql question: select every day another quote (Janning Vygen <vygen@planwerk6.de>) |
Ответы |
Re: newbie sql question: select every day another quote
|
Список | pgsql-general |
Am Samstag, 12. Mai 2001 14:37 schrieb Len Morgan: > >lastdayshown is always null on insert. > >works fine. Now i want to select every day a different quote. > > > >Is it possible to > >select the row with lastdayshown = today > > SELECT * FROM quotes WHERE lastdayshown = now()::date ; > > >if no result Hi, thanks for your answer i already manages this part :-) > The "no result part" is harder. You'll have to have some sort of client > program that can tell you if the above quote returned a row or not. Once > you have that, if the above query did NOT return a row, you can use the > following two steps: > > UPDATE quotes SET lastdayshown = now():: WHERE oid = (SELECT oid FROM > quotes WHERE lastdayshown IS NULL LIMIT 1) ; i managed this now in php. works fine but the idea was to put this structure into the database, so the db user just have to send one select and once a day there is an automagical update. maybe its not possible... thanks janning -- Planwerk 6 /websolutions Herzogstraße 86 40215 Düsseldorf fon 0211-6015919 fax 0211-6015917 http://www.planwerk6.de
В списке pgsql-general по дате отправления: