RE: [mv] (forw) Re: [ic] Interchange + PostgreSQL results in error 505's (premature end of script headers)

["Warren Odom" <warren-odom@stenocall.com>]

******    message to minivend-users from "Warren Odom" <warren-odom@stenocall.com>     ******

>******    message to minivend-users from Mike Heins <mikeh@minivend.com>
******

>I still don't understand how NOT NULL works in Postgres, and no one
>has been able to elucidate it. It appears to me that if you do
>       INSERT (username,password) INTO userdb
>       VALUES ('user', ");
>that it will error out on NOT NULL. This is at odds with my understanding
of how it should work; NOT NULL >appearse to be the moral equivalent of "NOT
BLANK".

Although I haven't dived (yet) into getting MV/IC running with Postgres,
your comment got me curious.  I know that in databases I've seen, NULL is
separate and distinct from"blank".  Just to be sure, I created a test table
in PG (I have version 6.5.3 on Red Hat) and set one of the columns "char
varying(5) not null".  I was able to insert a zero-length string into that
column using the above syntax (two single quotes placed together as in '').

           -- Warren

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list