Re: Clean up shop database
| От | Richard Klingler |
|---|---|
| Тема | Re: Clean up shop database |
| Дата | |
| Msg-id | 20220119143718285650.48772b27@klingler.net обсуждение исходный текст |
| Ответ на | Re: Clean up shop database (Rob Sargent <robjsargent@gmail.com>) |
| Ответы |
Re: Clean up shop database
RE: Clean up shop database |
| Список | pgsql-sql |
On Wed, 19 Jan 2022 06:32:19 -0700, Rob Sargent wrote: > >> No it does not...but I assume it lists products that where at least >> ordered before January 1st 2021 >> as it contains lower product IDs. >> >> Hmm..gives me: >> >>> ERROR: function max(boolean) does not exist >> LINE 5: having max(o.orderdate < '2021-01-01') >> >> > Sorry >> >> max(o.orderdate )< '2021-01-01' > >> You're a genius :-) Looks perfect... kiitoksia richard
В списке pgsql-sql по дате отправления: