>
>
> My apologies for correcting you yet again, hence the questions here in the
group meant for such questions:
DBS[:searches_t].
where{(exclude(search_phrase: nil))}.
select(:search_phrase, :result_count)
ERROR. *HINT: No function matches the given name and argument types. You
might need to add explicit type casts. *Points to "exclude"
The "Where TRUE" is what the .sql is explaining. From here:
where{(exclude(:search_phrase = nil) & (:client_ip != '192.168.1.4')}.
Question still not answered. I've simplified the query to the following,
which still has no answer:
DBS[:searches_t].
where{(exclude(search_phrase: nil))}.
select(:search_phrase, :result_count)
I've also tried:
DBS[:searches_t].
where{(:search_phrase != nil)}.
select(:search_phrase, :result_count)
=> provides nils. So that doesn't work.
I've also tried:
DBS[:searches_t].
where{(:search_phrase !~ nil)}.
select(:search_phrase, :result_count)
=> provides nils. Doesn't work.
I'm reading as much as I can, and wish to avoid coming in here. Believe
me.
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/37e2cf0c-5960-4ed9-83f2-5749d04f9f27%40googlegroups.com.
