| From: | "Rob Richardson" <Rob(dot)Richardson(at)rad-con(dot)com> |
|---|---|
| To: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Query help, please |
| Date: | 2010-09-09 15:43:15 |
| Message-ID: | 04A6DB42D2BA534FAC77B90562A6A03D015545DA@server.rad-con.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
Greetings!
A charge consists of a set of coils arranged in one or more stacks. It
is possible for a stack to be empty. I need a query that lists all
possible stacks, along with the coils that are in each stack (if any).
Charge 1 can have 4 stacks. Only stacks 2 and 3 are in use. A plain
ordinary query can get me:
Stack Coil Position
2 A 1
2 B 2
3 C 1
3 D 2
I need:
Stack Coil Position
1
2 A 1
2 B 2
3 C 1
3 D 2
4
The query is allowed to include the maximum possible number of stacks,
which is 8.
How can I get a result like this?
Thanks very much!
RobR
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2010-09-09 15:52:30 | Re: Regular expression in an if-statement will not work |
| Previous Message | Ungermann Carsten | 2010-09-09 15:36:38 | Re: Regular expression in an if-statement will not work |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Richardson | 2010-09-09 17:13:59 | Re: Query help, please |
| Previous Message | Tom Lane | 2010-09-09 15:16:36 | Re: Forcing the right queryplan |