Home > mailing lists

Re: Query help - Mailing list pgsql-general

From	Hui Xie
Subject	Re: Query help
Date	August 15, 2008 01:51:57
Msg-id	OFB1CBE105.276EC3F1-ON482574A6.0009C69A-482574A6.0009D319@as03.axiscan.com Whole thread Raw
In response to	Query help (novice <user.postgresql@gmail.com>)
List	pgsql-general

Tree view

Hi ,

below can work?
select config_id, start_day as day, start_time, end_time from config
union
select config_id, end_day as day, start_time, end_time from config

Best Regards,
Hui Xie
-------------------------------------------
Axisoft Co. Ltd. Zhuhai Branch
Tel: (86) 0756-3612121 8858

novice <user.postgresql@gmail.com>
Sent by: pgsql-general-owner@postgresql.org

15/08/2008 08:32 AM

To	pgsql-general@postgresql.org
cc
Subject	[GENERAL] Query help

Hi, I have a table select id, config_id, start_day, end_day, start_time, end_time from config; id | config_id | start_day | end_day | start_time | end_time -----+-----------+-----------+---------+------------+---------- 1 | 101 | Mon | Sun | 08:30:00 | 18:00:00 2 | 101 | Mon | Sun | 18:00:00 | 22:00:00 3 | 555 | Mon | Fri | 08:30:00 | 16:00:00 I'd like to write a query to generate the following... is it possible at all? config_id | day | start_time | end_time -----------+-----------+---------+------------- 101 | Mon | 08:30:00 | 18:00:00 101 | Mon | 18:00:00 | 22:00:00 101 | Tue | 08:30:00 | 18:00:00 101 | Tue | 18:00:00 | 22:00:00 101 | Wed | 08:30:00 | 18:00:00 101 | Wed | 18:00:00 | 22:00:00 101 | Thu | 08:30:00 | 18:00:00 101 | Thu | 18:00:00 | 22:00:00 101 | Fri | 08:30:00 | 18:00:00 101 | Fri | 18:00:00 | 22:00:00 101 | Sat | 08:30:00 | 18:00:00 101 | Sat | 18:00:00 | 22:00:00 101 | Sun | 08:30:00 | 18:00:00 101 | Sun | 18:00:00 | 22:00:00 555 | Mon | 08:30:00 | 18:00:00 555 | Tue | 08:30:00 | 18:00:00 555 | Wed | 08:30:00 | 18:00:00 555 | Thu | 08:30:00 | 18:00:00 555 | Fri | 08:30:00 | 18:00:00 Thanks -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general *** The email has been scanned by AxiScan ***

pgsql-general by date:

From: "Dale Harris"
Date: 15 August 2008, 00:44:38
Subject: Re: cannot use result of (insert .. returning)

From: Craig Ringer
Date: 15 August 2008, 01:59:09
Subject: Re: Custom sort

Re: Query help - Mailing list pgsql-general

Previous

Next