Postgres Pro
Downloads
Home   >   mailing lists

Thread: MOD

MOD

From
Tyler Wood
Date:
Hello,
I'm updating an existing postgres database, and using
perl with dbi to
access it.

Everything works fine,
I'm just not sure what this MOD command means.
Not asking you to figure it out in this context,
but just what does MOD do?


$sqh = $dbh->prepare("select
name,namelink,address,city,state,zip,email
        from company where MOD(nextscreen,2)=1 order
by $sort_selection;");
        $sqh->execute();



thank you,

Tyler Wood
twood@uwm.edu

__________________________________________________
Do You Yahoo!?
Get Yahoo! Mail � Free email you can access from anywhere!
http://mail.yahoo.com/

Re: MOD

From
Chris Bitmead
Date:
MOD is the remainder after division.

MOD(10, 3) = 1
MOD(11, 3) = 2
MOD(12, 3) = 0
MOD(13, 3) = 1

etc.

Tyler Wood wrote:
>
> Hello,
> I'm updating an existing postgres database, and using
> perl with dbi to
> access it.
>
> Everything works fine,
> I'm just not sure what this MOD command means.
> Not asking you to figure it out in this context,
> but just what does MOD do?
>
> $sqh = $dbh->prepare("select
> name,namelink,address,city,state,zip,email
>         from company where MOD(nextscreen,2)=1 order
> by $sort_selection;");
>         $sqh->execute();
>
> thank you,
>
> Tyler Wood
> twood@uwm.edu
>
> __________________________________________________
> Do You Yahoo!?
> Get Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/

Re: MOD

From
"Len Morgan"
Date:
>Not asking you to figure it out in this context,
>but just what does MOD do?
>
>
>$sqh = $dbh->prepare("select
>name,namelink,address,city,state,zip,email
>        from company where MOD(nextscreen,2)=1 order
>by $sort_selection;");
>        $sqh->execute();
>

I believe it's just trying to figure out if "nextscreen" is odd or even.  1
would odd, 0 even.

len morgan

Re: MOD

From
John McKown
Date:
On Mon, 17 Jul 2000, Tyler Wood wrote:

> name,namelink,address,city,state,zip,email
>         from company where MOD(nextscreen,2)=1 order

MOD is short for MODulus, which means the remainder after division. In
the above, it divides nextscreen by 2. If the remainder is 1, then it
selects the row. I.e. "If nextscreen is odd"

John McKown