Also sprach Tom Lane ([EMAIL PROTECTED])
> "Stefan 'Kaishakunin' Schumacher" <[EMAIL PROTECTED]> writes:
> > I have a table with an array column (tags text[]) which I want to
> > select from via ANY and RegExes.
>
> > SELECT tags from zettelkasten where 'Sozialpsychologie' ~* any(tags) order
> >
"Stefan 'Kaishakunin' Schumacher" <[EMAIL PROTECTED]> writes:
> I have a table with an array column (tags text[]) which I want to
> select from via ANY and RegExes.
> SELECT tags from zettelkasten where 'Sozialpsychologie' ~* any(tags) order by
> ident;
Did you look at the matches? I suspect
I have a table with an array column (tags text[]) which I want to
select from via ANY and RegExes.
SELECT tags from zettelkasten where 'Sozialpsychologie' ~* any(tags) order by
ident;
delivers 7 rows
SELECT tags from zettelkasten where 'SoziALPSychologie---FOOBARBAZ' ~*
any(tags)
order by
