Re: [GENERAL] How to check if an array is empty

2008/9/11 Tobias Anstett <[EMAIL PROTECTED]>: > Hi, > > > > in my special case I'd like to check if a XML[] is empty, because postgres > doesn't implement any equality operators, this is not a 'simple' task. > > > > My current solution is: > > > > SELECT * FROM sometable WHERE XMLSERIALIZE(CONTENT

[GENERAL] How to check if an array is empty

Hi, in my special case I'd like to check if a XML[] is empty, because postgres doesn't implement any equality operators, this is not a 'simple' task. My current solution is: SELECT * FROM sometable WHERE XMLSERIALIZE(CONTENT ((XPATH('/a:bar, somexmlcolumn, ARRAY[ARRAY['a', 'http://foo]]