; Sent: Mittwoch, 23. Februar 2005 18:20
> C:\> To: WeiShang
> C:\> Cc: pgsql-sql@postgresql.org
> C:\> Subject: Re: [SQL] VIEW / ORDER BY + UNION
> C:\>
> C:\>
> C:\> On Thu, Feb 17, 2005 at 23:46:59 +0800,
> C:\> WeiShang <[EMAIL PROTECTED]>
; Cc: pgsql-sql@postgresql.org
C:\> Subject: Re: [SQL] VIEW / ORDER BY + UNION
C:\>
C:\>
C:\> On Thu, Feb 17, 2005 at 23:46:59 +0800,
C:\> WeiShang <[EMAIL PROTECTED]> wrote:
C:\> > Hi, I have created a view like this :
C:\> >
C:\> > CREATE VIEW v1 AS (SELECT orde
On Thu, Feb 17, 2005 at 23:46:59 +0800,
WeiShang <[EMAIL PROTECTED]> wrote:
> Hi, I have created a view like this :
>
> CREATE VIEW v1 AS (SELECT orderno,weekday,time FROM t1,t2 where
> t1.orderno=t2.orderno);
>
> if I create a SQL statment:
>
> (SELECT orderno FROM v1 WHERE weekday='MON' ORDE
hi,
WeiShang wrote, On 2/17/2005 16:46:
Hi, I have created a view like this :
CREATE VIEW v1 AS (SELECT orderno,weekday,time FROM t1,t2 where
t1.orderno=t2.orderno);
if I create a SQL statment:
(SELECT orderno FROM v1 WHERE weekday='MON' ORDER BY orderno)
UNION
(SELECT orderno FROM v1 WHERE weekday
Hi, I have created a view like this :
CREATE VIEW v1 AS (SELECT orderno,weekday,time FROM t1,t2 where
t1.orderno=t2.orderno);
if I create a SQL statment:
(SELECT orderno FROM v1 WHERE weekday='MON' ORDER BY orderno)
UNION
(SELECT orderno FROM v1 WHERE weekday='WED' ORDER BY orderno)
UNION
(SELEC
