Re: IS NULL

Tom Lane wrote:
>
> David Link <dlink(at)soundscan(dot)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