This may work
query="regexp_replace(lower(titel), '[ -,.:]', '', 'g') =
regexp_replace(lower('SAMj -South african Medical Journal'),
'[,.:]', '', 'g')"
db(query).select(db.joernaal.titel)
On Nov 4, 5:14 am, Johann Spies <johann.sp...@gmail.com> wrote:
> In order to solve inconsistent typing by either people who capture
> data or people using search functions I intend to use something like
> this in SQL (Postgresql):
>
> select titel from joernaal
> where
> regexp_replace(lower(titel), '[ -,.:]', '', 'g') =
> regexp_replace(lower('SAMj -South african Medical Journal'), '[
> ,.:]', '', 'g')
>
> The last line can be handled by python using the input from a form. I
> want Postgresql to handle the second last line.
>
> I suspect this type of query is not possible using DAL (or is it?) and
> that I will have to use executesql for that?
>
> Regards
> Johann
> --
> May grace and peace be yours in abundance through the full knowledge
> of God and of Jesus our Lord! His divine power has given us
> everything we need for life and godliness through the full knowledge
> of the one who called us by his own glory and excellence.
> 2 Pet. 1:2b,3a
