SQL-Statment

From: christoph(dot)dellavalle(at)goetheanum(dot)ch
To: pgsql-novice(at)postgresql(dot)org
Subject: SQL-Statment
Date: 2003-11-28 15:22:19
Message-ID: D1ECCF616FF6D611A3C3000102755F454D5884@s2bdcmail.aag
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi there

I'm trying to compact an imported table. Any suggestions how this can be done:

Table now:

ID attr1 attr2
1 5 NULL
1 NULL 7
2 8 NULL
3 NULL 4
4 NULL NULL

The Result should look like this:

ID attr1 attr2
1 5 7
2 8 NULL
3 NULL 4
4 NULL NULL

Thanks for every hint.

Chris

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2003-11-28 16:31:20 Re: SQL-Statment
Previous Message Jukka Ylönen 2003-11-27 15:46:18 Re: about psql functions...