Re: [GENERAL] Composite type evaluates to Null if any element is null

2008-12-17 Thread Merlin Moncure
On Wed, Dec 17, 2008 at 12:23 PM, Andrew Gould wrote: > What are composite types used for? Do they allow you to search multiple > fields for a value more easily? A number of things really. Starting with 8.4, they can be used with indexes and comparisons. so the list is growing. The main utilit

Re: [GENERAL] Composite type evaluates to Null if any element is null

2008-12-17 Thread Andrew Gould
What are composite types used for? Do they allow you to search multiple fields for a value more easily? Thanks, Andrew

Re: [GENERAL] Composite type evaluates to Null if any element is null

2008-12-17 Thread Merlin Moncure
On Wed, Dec 17, 2008 at 11:09 AM, Ketema Harris wrote: > I have just re-read chapter 8.15 of the 8.3 manual and I am understanding > why a composite type would evaluate to NUll if any of it elements are null. > > Can anyone explain this behavior? To me if I have a composite type column > and ther