Re: What does # mean in plpgsql? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: What does # mean in plpgsql?
Date
Msg-id AANLkTi=55Q3Bxkmix_NfLiKxOzFSh9Te-1zO3RRC+fpE@mail.gmail.com
Whole thread Raw
In response to What does # mean in plpgsql?  (Stephen Cook <sclists@gmail.com>)
Responses Re: What does # mean in plpgsql?
Re: What does # mean in plpgsql?
List pgsql-general
hello

try:

postgres=# select oprcode, oprleft::regtype, oprright::regtype from
pg_operator where oprname = '#';
    oprcode    | oprleft  | oprright
---------------+----------+----------
 path_npoints  | -        | path
 box_intersect | box      | box
 poly_npoints  | -        | polygon
 lseg_interpt  | lseg     | lseg
 line_interpt  | line     | line
 bitxor        | bit      | bit
 int2xor       | smallint | smallint
 int4xor       | integer  | integer
 int8xor       | bigint   | bigint
(9 rows)

so this means a xor operation

regards

Pavel Stehule

2010/8/12 Stephen Cook <sclists@gmail.com>:
> What does the hash mark (#) mean in plpgsql?
>
> I saw it used in the pseudo_encrypt function @
> http://wiki.postgresql.org/wiki/Pseudo_encrypt, on the line:
>
> r2 := l1 # ((((1366.0 * r1 + 150889) % 714025) / 714025.0) * 32767)::int;
>
> My google-fu has failed me on this one, and I needs to know.
>
> Thanks!
>
>
> -- Stephen
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

pgsql-general by date:

Previous
From: Stephen Cook
Date:
Subject: What does # mean in plpgsql?
Next
From: Adrian Klaver
Date:
Subject: Re: What does # mean in plpgsql?