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(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>