Search Postgresql Archives

Re: What does # mean in plpgsql?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx>:
> 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@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux