Re: [BUGS] possible mis-handling of nulls in views in 7.0.2

2001-03-12 Thread Mark Stosberg
Tom, I tried to build a simple test case and I couldn't reproduce either. I'm still actively working with that database, though-- If I run into it again, and can reproduce a condensed case, I'll definitely submit it. It sounds like views are being improved a good deal in 7.1, so perhaps my oddi

Re: [BUGS] possible mis-handling of nulls in views in 7.0.2

2001-03-12 Thread Tom Lane
Mark Stosberg <[EMAIL PROTECTED]> writes: >I'm running Postgres 7.0.2 and have run into a curious situation. I > got a back a null value in a select on VIEW that is defined as not > allowing that column to be null. I think this is an artifact of the curious (not to say broken) implementation

[BUGS] possible mis-handling of nulls in views in 7.0.2

2001-03-12 Thread Mark Stosberg
Hello, I'm running Postgres 7.0.2 and have run into a curious situation. I got a back a null value in a select on VIEW that is defined as not allowing that column to be null. Here's a screenshot: marvel=> \d shipments; View= shipments Query = SELECT "web_data"."shipment_id", "web_data"