On Oct 12, 2010, at 12:53 , Josh Kupershmidt wrote:
> On Tue, Oct 12, 2010 at 11:28 AM, Rebecca Cooper
> <rebecca.cooper@newforestnpa.gov.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