Re: [SQL] Bad (null) varchar() external representation

2001-01-11 Thread Tom Lane
Justin Clift <[EMAIL PROTECTED]> writes: > "Bad (null) varchar() external representation" This is a known stupidity in 7.0.* and before: length(varchar) doesn't like NULLs: play=> select length(null::varchar); ERROR: Bad (null) varchar() external representation It's fixed for 7.1. If it's rea

[SQL] Bad (null) varchar() external representation

2001-01-09 Thread Justin Clift
Hi all, I'm getting the following problem when trying to do a simple insert statement... "Bad (null) varchar() external representation" WHY? I'm running PostgreSQL 7.03 on Linux Mandrake 7.2 (using a specially compiled version, not an RPM). Here's the table : foobar=# \d staff_details