Re^2: duplicate key check isn't, why not?


XP is just a number
	PerlMonks

Re^2: duplicate key check isn't, why not?

by hesco (Deacon)

on Nov 23, 2008 at 16:22 UTC ( [id://725440]=note: print w/replies, xml )

Need Help??

in reply to Re: duplicate key check isn't, why not?
in thread duplicate key check isn't, why not?

Thanks for turning this one over for a moment.

=# SELECT * FROM mlg_addr WHERE mlg_addr_id = '';
ERROR:  invalid input syntax for integer: ""
=# SELECT * FROM mlg_addr WHERE mlg_addr_id IS NULL;
 mlg_addr_id | address1 | address2 | city | state | zipcode5 | zipcode
+4 | country
-------------+----------+----------+------+-------+----------+--------
+--+---------
(0 rows)
[download]

if( $lal && $lol ) { $life++; }