Re: MOD

Поиск
Список
Период
Сортировка
От Chris Bitmead
Тема Re: MOD
Дата
Msg-id 3973BC7F.71145044@nimrod.itg.telecom.com.au
обсуждение исходный текст
Ответ на MOD  (Tyler Wood <electric_pancake@yahoo.com>)
Список pgsql-general
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/

В списке pgsql-general по дате отправления:

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: From timestamp to seconds since epoch?
Следующее
От: "Len Morgan"
Дата:
Сообщение: Re: MOD