On 01/03/2011 12:11 PM, Andre Lopes wrote:
As far as I understand NULL values are not really stored and a column with many NULLs is not a problem as such, but if it is part of an index the index might not be very useful.[snip]The problem with this task is that the information is not linear, if I try to design tables with fields for all possible data I will end up with many row fields with NULL values. There are any problem with this(end up with many row fields with NULL values)? Or should I user other kind of structure? For example store the data in one field and that field containing an associative array with data.
At least that's my understanding of how SQL databases work. If I got this wrong I hope someone will correct me.
[snip]
/Fredric
<<attachment: Fredric_Fredricson.vcf>>
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
