I'm using postgres:pg8000
But I clearly did not read the documentation well enough - the
`contains('%Smith')` does the trick perfectly.
Thanks
On Wednesday, April 29, 2015 at 3:20:37 AM UTC-7, Paolo Valleri wrote:
>
> Which postgres adapter are you using?
> Try
> - contains('%Smith')
> and (fo
isn't the problem here that for list:string contains doesn't behave as a
"like" but as the "contains" in python ?!?!?!
On Wednesday, April 29, 2015 at 12:20:37 PM UTC+2, Paolo Valleri wrote:
>
> Which postgres adapter are you using?
> Try
> - contains('%Smith')
> and (for case-insensitive query)
Which postgres adapter are you using?
Try
- contains('%Smith')
and (for case-insensitive query)
- contains('%smith', case_sensitive=False)
Paolo
On Tuesday, April 28, 2015 at 9:26:24 PM UTC+2, Tom Stratton wrote:
>
> For me, with the postgres adapter, the "contains" method is only returning
> i
For me, with the postgres adapter, the "contains" method is only returning
information when one of the items in the list is an exact match (case
insensitive) for the item I search for.
so if the list is ['John Doe', 'Michael Smith', 'Karen Jones', 'Anne Baker']
contains('Michael Smith') returns
db.tablename.fieldname.contains('whatever')
On Saturday, 25 April 2015 10:28:10 UTC-5, Tom Stratton wrote:
>
> Hi -
>
> I'm struggling to find a way to do an "ilike" style search within a list
> of strings field in the db.
>
> For example, my field may contain ['Donald Duck', 'Minnie Mouse']
>
>
5 matches
Mail list logo