Re: What does # mean in plpgsql?

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
>