Re: What does # mean in plpgsql?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Stephen Cook <sclists(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: What does # mean in plpgsql?
Date: 2010-08-12 15:06:28
Message-ID: 14432.1281625588@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> writes:
> try:

> postgres=# select oprcode, oprleft::regtype, oprright::regtype from
> pg_operator where oprname = '#';

Or even easier:

regression=# \do+ #
List of operators
Schema | Name | Left arg type | Right arg type | Result type | Description
------------+------+---------------+----------------+-------------+--------------------------------
pg_catalog | # | bigint | bigint | bigint | bitwise xor
pg_catalog | # | bit | bit | bit | bitwise exclusive or
...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2010-08-12 15:12:42 Re: MySQL versus Postgres
Previous Message Daniel Verite 2010-08-12 15:00:55 Re: What does # mean in plpgsql?