Re: IS NULL

Tom Lane wrote:
>
> David Link <dlink@soundscan.com> writes:
> > Tom Lane wrote:
> >> This is a bug.  What version are you using?  Could you supply
> >> an exact example of a value that makes it crash?
>
> > bobcat=# select upckey, upc, title, theatre_reldate, genre, subgenre
> > from title
> >  where upckey = 77703;
> >  upckey |     upc      |   title    | theatre_reldate | genre | subgenre
> > --------+--------------+------------+-----------------+-------+----------
> >   77703 | 339660005072 | HOLLOW MAN | 2000            | 944   | x
> > (1 row)
>
> Could I trouble you for the exact datatypes of these columns, too?
>
>                         regards, tom lane

Sure thing:  varchar(4)

Please note, I've  inherrited this.  The original system was all flat
files and I'm in the process of migrating to the relational world.

bobcat=# \d title
                                 Table "title"
    Attribute    |     Type     |
Modifier
-----------------+--------------+----------------------------------------------
 upckey          | integer      | not null default
nextval('upckey_seq'::text)
 upc             | varchar(12)  | not null
 media           | varchar(2)   | not null
 title           | varchar(30)  | not null
 artist          | varchar(30)  |
 distributor     | varchar(10)  |
 retail_reldate  | varchar(10)  |
 theatre_reldate | varchar(4)   |
 genre           | varchar(10)  |
 subgenre        | varchar(10)  |
 rating          | varchar(10)  |
 animation       | varchar(2)   |
 brand           | varchar(10)  |
 orig_lang       | varchar(10)  |
 rel_lang        | varchar(10)  |
 language_usage  | varchar(2)   |
 run_time        | numeric(4,0) |
 screen_format   | varchar(2)   |
 msrp            | varchar(7)   |
 source          | varchar(2)   |
 source_dvd      | varchar(2)   |
 rel_status      | varchar(2)   |
 box_office      | varchar(10)  |
 box_office_cd   | varchar(10)  |
 edi_code        | varchar(10)  |
 c_mode          | varchar(2)   |
 uncv            | varchar(2)   |
 blob            | varchar(2)   |
 datein          | varchar(8)   |
 dateup          | varchar(8)   |
Index: title_pkey