Re: please give me select sqls examples to distinct these! - Mailing list pgsql-general

From Rob Sargent
Subject Re: please give me select sqls examples to distinct these!
Date
Msg-id 8E137936-5D93-49FF-93A3-EB4E97D3416C@gmail.com
Whole thread Raw
In response to please give me select sqls examples to distinct these!  ("jacktby@gmail.com" <jacktby@gmail.com>)
Responses Re: please give me select sqls examples to distinct these!
List pgsql-general


On Oct 25, 2022, at 7:55 AM, jacktby@gmail.com wrote:

body { line-height: 1.5; } body { font-size: 14px; font-family: "Microsoft YaHei UI"; color: rgb(0, 0, 0); line-height: 1.5; }

typedef enum SetOperation
{
    SETOP_NONE = 0,
    SETOP_UNION,
    SETOP_INTERSECT,
    SETOP_EXCEPT
} SetOperation;

jacktby@gmail.com

Please use just text. 
What ‘dialect’ are using? In Postgres
0: select * from table
1: select * from table union select * from table is same shape
2: select * from table join table b on Id = idb 
3: select * from table except select * from tableb

pgsql-general by date:

Previous
From: "jacktby@gmail.com"
Date:
Subject: please give me select sqls examples to distinct these!
Next
From: "jacktby@gmail.com"
Date:
Subject: Re: Re: please give me select sqls examples to distinct these!