On Sat, Feb 10, 2018 at 4:40 AM, PG Doc comments form <
nore...@postgresql.org> wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.5/static/queries-order.html
> Description:
>
> This works:
>
> select distinct o.bid, organisatio
Alvaro Herrera writes:
> PG Doc comments form wrote:
>> create table t(x int);
>> create table u(x int);
>>
>> insert into t values (1), (2), (2), (3), (3);
>> insert into u values (1), (2);
>>
>> select * from t except all select * from u;
>> x
>> ---
>> 3
>> 3
>> 2
>> (3 rows)
> I find this
=?utf-8?q?PG_Doc_comments_form?= writes:
> This does not work:
> select distinct (o.bid), organisation, posttown, replace(case when postcode
> ='' then null else trim(postcode) end, ' ', '') as pc, phone, o.active,
> website, email, (select count(*) from notes as n where n.bid = o.bid) as nn
> f
On Saturday, February 10, 2018, PG Doc comments form
wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.5/static/queries-order.html
> Description:
>
> This works:
>
> select distinct o.bid, organisation, posttown, replace(case
On Sat, Feb 10, 2018 at 1:02 PM, Pantelis Theodosiou
wrote:
>
>
> On Sat, Feb 10, 2018 at 11:59 AM, Alvaro Herrera
> wrote:
>
>> PG Doc comments form wrote:
>>
>> > create table t(x int);
>> > create table u(x int);
>> >
>> > insert into t values (1), (2), (2), (3), (3);
>> > ins
On Sat, Feb 10, 2018 at 11:59 AM, Alvaro Herrera
wrote:
> PG Doc comments form wrote:
>
> > create table t(x int);
> > create table u(x int);
> >
> > insert into t values (1), (2), (2), (3), (3);
> > insert into u values (1), (2);
> >
> > select * from t except all select * fr
PG Doc comments form wrote:
> create table t(x int);
> create table u(x int);
>
> insert into t values (1), (2), (2), (3), (3);
> insert into u values (1), (2);
>
> select * from t except all select * from u;
> x
> ---
> 3
> 3
> 2
> (3 ro
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/static/queries-order.html
Description:
This works:
select distinct o.bid, organisation, posttown, replace(case when phone =''
then null else trim(phone) end, ' ', ''), phone, o.active, w
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.3/static/runtime-config-connection.html
Description:
Engineering The Future
