CASE WHEN ERROR: Void value

From: "Thomas T(dot) Thai" <tom(at)minnesota(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: CASE WHEN ERROR: Void value
Date: 2003-03-20 08:53:48
Message-ID: Pine.NEB.4.44.0303200251580.13142-100000@ns01.minnesota.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


What does this error mean:

tsearch=# select case when title_fts is null then '' else title_fts end
from article;
ERROR: Void value
tsearch=#

title_fts is datatype txtidx. If the '' is replaced with 'anything' then
it works fine.

--
Thomas T. Thai

Browse pgsql-general by date

  From Date Subject
Next Message Ferruccio Zamuner 2003-03-20 09:33:05 search_path for schemas
Previous Message Joel Rodrigues 2003-03-20 08:27:46 PostgreSQL downloads compressed with bzip2 instead of gzip ?