SQL-Statment - Mailing list pgsql-novice

From christoph.dellavalle@goetheanum.ch
Subject SQL-Statment
Date
Msg-id D1ECCF616FF6D611A3C3000102755F454D5884@s2bdcmail.aag
Whole thread Raw
Responses Re: SQL-Statment
List 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



pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to run 2+ versions of PostgreSQL concurrently
Next
From: Bruno Wolff III
Date:
Subject: Re: SQL-Statment