Re: NonNullValue() error in 8.4

On Oct 12, 2010, at 12:53 , Josh Kupershmidt wrote:

> On Tue, Oct 12, 2010 at 11:28 AM, Rebecca Cooper
> <rebecca(dot)cooper(at)newforestnpa(dot)gov(dot)uk> wrote:
>> We have recently upgraded to 8.4 from 8.3 and are experiencing problems with
>> a client application. The log files record multiple entries of -
>>
>> SELECT NonNullValue(attname) AS has_oid FROM pg_attribute
>>
>> ERROR: function nonnullvalue(name) does not exist at character 664
>>
>

> to use a CASE statement like so:
>
> SELECT (CASE WHEN attname IS NULL THEN true ELSE false END) AS
> has_oid FROM pg_attribute;
>
> which should work fine on 8.4.

Or just "SELECT attname IS NULL AS has_oid"

Michael Glaesemann
grzm seespotcode net