rds,
S.
***********
Sergey E. Koposov, PhD
Institute for Astronomy, University of Cambridge, UK
Web: http://lnfm1.sai.msu.ru/~math
E-mail: m...@sai.msu.ru
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
On Tue, 4 May 2010, Tom Lane wrote:
"Sergey E. Koposov" writes:
So among 10^5 random numbers there are already 3 collisions. Which doesn't
seem right for the function which generate randoms of double precision
The underlying random() function only generates 31-bit integers,
g).
Does anyone have an explanation for what I see ? Did I miss something
obvious ?
Thanks in advance,
Sergey
***
Sergey E. Koposov, PhD
Institute for Astronomy, University of Cambridge, UK
Web: http://lnfm1.sai.msu.ru/
ace.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: analyzing "public.xx"
INFO: "xx": scanned 3000 of 554353 pages, containing 8907 live rows and 0
dead rows; 3000 rows in sample, 1645874 estimated total rows
VACUUM
***
.html
But, in any way, if you want your aggregate to return several values, you
can always return them as the elements in the array.
Regards,
Sergey
***
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astrono
that normal? I really do not see the reason for the error. I even don't
use the "GROUP BY" clause. Am I wrong ?
(I'm using PG 8.1.3)
Thanks in advance for any advices.
Regards,
Sergey
*********
Sergey E. Koposov
Max Planck
hing like
echo "250 32000 32 16000" > /proc/sys/kernel/sem
(compute the exact numbers by yourself)
But I really doubt that it it possible/reasonable to have 1
simultaneous connections.
Also you can setup the semaphore numbers using sysctl
sysctl -w kernel.sem="250
On Fri, 2 Sep 2005, Tom Lane wrote:
> "Sergey E. Koposov" <[EMAIL PROTECTED]> writes:
> > I'm interested in simplifying those queries and introducing the operator
> > doing something like this:
>
> > my_operator(bigint x, bigint[] arr)
> > ch
Hello All,
I have a following question:
I'm using some set of queries like:
SELECT * FROM
(SELECT my_function(ra, dec, 0.001) AS ipix1, ra1, dec1
FROM table1) AS jtable1, table2
WHERE table2.ipix>=ipix1[1] AND table2.ipix<=ipix1[2] );
ipix is bigint column, on which the Btree