On Fri, 11 Jun 2021 at 02:35, Alvaro Herrera <alvhe...@alvh.no-ip.org> wrote:
>
> On 2021-Jun-10, David Rowley wrote:
> > My regex foo is not strong enough to think how I might find multiline
> > instances.
>
> This catches some of these:
>
> ag "\sa[\s*]*\n[\s*]*(A|E|F|H|I|L|M|N|O|S|X)[A-Z]{2,5}\s"
Thanks. I ended up using -C 1 and manually checking the previous line.
> You get a bunch of "a NULL" or "a NOT" and so on, but here's a few valid ones:
>
> contrib/tablefunc/tablefunc.c:316: * crosstab - create a crosstab of rowids
> and values columns from a
> contrib/tablefunc/tablefunc.c:317: * SQL statement returning one rowid
> column, one category column,
>
> contrib/tablefunc/tablefunc.c:607: * crosstab - create a crosstab of rowids
> and values columns from a
> contrib/tablefunc/tablefunc.c:608: * SQL statement returning one rowid
> column, one category column,
>
> doc/src/sgml/plpgsql.sgml
> 1127: The result of a
> 1128: SQL command yielding a single row (possibly of multiple
>
> src/backend/catalog/pg_subscription.c:438: *
> translator: first %s is a SQL ALTER command and second %s is a
> src/backend/catalog/pg_subscription.c:439: * SQL DROP
> command
>
> src/backend/replication/logical/logical.c:126: * 1) We need to be able to
> correctly and quickly identify the timeline a
> src/backend/replication/logical/logical.c:127: * LSN belongs to
>
> src/backend/libpq/auth.c:847: * has. If it's an MD5 hash, we must do MD5
> authentication, and if it's a
> src/backend/libpq/auth.c:848: * SCRAM secret, we must do SCRAM
> authentication.
Thanks. I've left all the .c file comments alone for no and looks like
I got the doc/src/sgml/plpgsql.sgml one already.
David
