Mailing List webobjects-dev@wocommunity.org Message #312
From: Jesse Tayler <webobjects-dev@wocommunity.org>
Subject: Re: [WO-DEV] How would you create such an EOQualifier representing Postgresql date_trunc(...)?
Date: Wed, 3 Nov 2021 09:25:51 -0400
To: WebObjects & WOnder Development <webobjects-dev@wocommunity.org>
 Message Header

Undecoded Message
I generally use ERXKeys and fancy methods called dot() and these good ideas let you code into the compiler the structure of whatever query you like to do.

I don’t see anything unusual about your qualifier? Want an example?

On Nov 3, 2021, at 8:48 AM, Markus Ruggiero (rucotec) <webobjects-dev@wocommunity.org> wrote:

No one?
I can live with raw rows but would have been great if anyone knows

---markus---

On 1 Nov 2021, at 12:54, Markus Ruggiero (rucotec) <webobjects-dev@wocommunity.org> wrote:

Need to find objects satisfying the following condition:

CHECK_IN_TIME must be at least on the same day or later than REQUESTED. Both values are stored as NSTimestamp with a 15 minutes precision.

In Postgres I would write

...where date_trunc('day', CHECK_IN_TIME) >= date_trunc('day', REQUESTED)

How can I create a qualifier for this? Is this possible at all or do I have to resort to raw rows for SQL?

Thanks
---markus---



Markus Ruggiero

rucotec GmbH                        web https://rucotec.ch
Steinenvorstadt 79                email markus.ruggiero@rucotec.ch
4051 Basel / Switzerland         mobile +41 79 508 4701











Subscribe (FEED) Subscribe (DIGEST) Subscribe (INDEX) Unsubscribe Mail to Listmaster