Re: Inline count on a query

On Wed, Aug 19, 2020 at 8:19 AM Laura Smith < n5d9xq3ti233xiyif...@protonmail.ch> wrote: > On Wednesday, 19 August 2020 15:09, David G. Johnston < > david.g.johns...@gmail.com> wrote: > > > On Wednesday, August 19, 2020, Laura Smith < > n5d9xq3ti233xiyif...@protonmail.ch> wrote: > > > > > Hi, > >

Re: Inline count on a query

On Wednesday, 19 August 2020 15:09, David G. Johnston wrote: > On Wednesday, August 19, 2020, Laura Smith > wrote: > > > Hi, > > > > Let's say we've got a fairly basic table : > > > > create table networks ( > > lan_id text not null, > > net_id text not null, > > port_id text not null > > ); >

Re: Inline count on a query

On Wednesday, August 19, 2020, Laura Smith < n5d9xq3ti233xiyif...@protonmail.ch> wrote: > Hi, > > Let's say we've got a fairly basic table : > > create table networks ( > lan_id text not null, > net_id text not null, > port_id text not null > ); > create index net_uniq on networks(lan_id,port_id);

Inline count on a query

Hi, Let's say we've got a fairly basic table : create table networks ( lan_id text not null, net_id text not null, port_id text not null ); create index net_uniq on networks(lan_id,port_id); The query conundrum I am facing is that I need to add metadata to the output of the query that indicates