"Magnus Naeslund(f)" <mag(at)fbab(dot)net> writes:
> SELECT DISTINCT
> *
> FROM
> (
> SELECT
> vtgm.snicker_id
> FROM snicker_group_mapping vtgm
> WHERE exists
> (
> SELECT
> *
> FROM snicker_group vtg
> WHERE vtgm.snicker_group_id = vtg.id
> AND lower(vtg.title) ~* 'test'
> )
> UNION
> SELECT
> snicker.id
> FROM snicker
> WHERE lower(snicker.name_singular) ~* 'test'
> OR lower(snicker.name_plural) ~* 'test'
> ) AS vt_id
> WHERE vt_id is not null;
While the crash is certainly a bug, the answer is going to be "don't do
that". Testing a whole record for null-ness is not meaningful.
regards, tom lane