How do I select arrays that are not empty?

5 votes

2 answers

30018 views

postgresql postgresql-9.5 null array condition

                          Why is this so tricky, what is token set to that it isn't equal to null nor an empty string?

    SELECT lexemes
    FROM ts_debug('This is a title')
    WHERE alias = 'asciiword';
    
     lexemes 
    ---------
     {}
     {}
     {}
     {titl}
    (4 rows)

Ok.. So I want to get rid of {},

    SELECT lexemes
    FROM ts_debug('This is a title')
    WHERE alias = 'asciiword'
      AND lexemes  '{}'
      AND lexemes  ARRAY[]::text[]
      AND lexemes IS NOT NULL
      AND lexemes  ARRAY[' ']
      AND lexemes  ARRAY[null]::text[];

**I knew most of these wouldn't work.**, but I'm totally confused why  '{}' wouldn't work not  ARRAY[]::text;. How do I filter this out?
                        

Asked by Evan Carroll (65502 rep)

Sep 23, 2017, 04:11 AM
Last activity: May 29, 2024, 01:32 PM

How do I select arrays that are not empty?

Related Questions