Horton
Menu

CASE WHEN ERROR: Void value

Thomas T. Thai <tom@minnesota.com>

View thread
From: "Thomas T. Thai" <tom@minnesota.com>
To: PostgreSQL General <pgsql-general@postgresql.org>
Date: 2003-03-20T08:53:48Z
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