Re: Use of '&' as table prefix in query - Mailing list pgsql-general

From Rich Shepard
Subject Re: Use of '&' as table prefix in query
Date
Msg-id alpine.LNX.2.20.2107121101020.7804@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Use of '&' as table prefix in query  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On Mon, 12 Jul 2021, Adrian Klaver wrote:


> You should also follow Tom's suggestion and do:
> \do+ &
> in psql.

It's the bitwise 'and':
# \do+ &
                                        List of operators
    Schema   | Name | Left arg type | Right arg type | Result type |   Function   | Description 
------------+------+---------------+----------------+-------------+--------------+-------------
  pg_catalog | &    | bigint        | bigint         | bigint      | int8and      | bitwise and
  pg_catalog | &    | bit           | bit            | bit         | bitand       | bitwise and
  pg_catalog | &    | inet          | inet           | inet        | inetand      | bitwise and
  pg_catalog | &    | integer       | integer        | integer     | int4and      | bitwise and
  pg_catalog | &    | macaddr       | macaddr        | macaddr     | macaddr_and  | bitwise and
  pg_catalog | &    | macaddr8      | macaddr8       | macaddr8    | macaddr8_and | bitwise and
  pg_catalog | &    | smallint      | smallint       | smallint    | int2and      | bitwise and
(7 rows)

which doesn't seem appropriate in this context.

Thanks,

Rich



pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Use of '&' as table prefix in query
Next
From: Rich Shepard
Date:
Subject: Re: Use of '&' as table prefix in query