Re: [GENERAL] Random not so random

2004-10-05 Thread D. Stimits
Vivek Khera wrote: DS == D Stimits [EMAIL PROTECTED] writes: DS If it uses the same seed from the connection, then all randoms within DS a connect that has not reconnected will use the same seed. Which means DS the same sequence will be generated each time, which is why it is DS pseudo-random

Re: [GENERAL] Random not so random

2004-10-04 Thread D. Stimits
. A pseudo-random generator using the same seed will generate the same sequence. D. Stimits, stimits AT comcast DOT net ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] import/export or moving data between databases

2004-09-19 Thread D. Stimits
Iavor Raytchev wrote: Dear Tom, We kind of read all documentation we could find, but that was the only way we could get - - export db structure into sql file - export the records we need into another sql file - import structure - turn off triggers - import the records - turn on triggers The main

Re: [GENERAL] [INTERFACES] more on undefined reference to 'pg_detoast_datum'

2003-10-13 Thread D. Stimits
Tom Lane wrote: D. Stimits writes: ... My question is, where the heck is CurrentMemoryContext and MemoryContextAlloc provided as an implementation which I can link with? They're inside the backend, and you don't --- you are not trying to build a standalone executable with no unresolved

Re: [GENERAL] PL/PGSQL for permutations?

2003-10-09 Thread D. Stimits
Joe Conway wrote: D. Stimits wrote: table field pair. E.G., if I had in table 'one': left right = a b a c b d ...then I'd need a list of a, b, c, d, and produce a new table: left right = a b a c a d b a b c b d c a c

[GENERAL] undefined reference to 'pg_detoast_datum'

2003-10-09 Thread D. Stimits
of PostgreSQL, then a newer version can't be used] D. Stimits ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] undefined reference to 'pg_detoast_datum'

2003-10-09 Thread D. Stimits
Joe Conway wrote: D. Stimits wrote: A google search shows very little concerning the pg_detoast_datum undefined reference link error. It is looking more like the V1 has to be skipped and I'll have to go back to V0 if I can't get this to work. You haven't shown us your function, so it's a bit

Re: [GENERAL] C API, PQconnectdb and options Q.

2003-09-10 Thread D. Stimits
D. Stimits wrote: I'm using a Redhat version of PostgreSQL 7.2.3 with the C API. Mostly things work right, but I need more debug output, as I have a query that works fine from psql, but fails with the C API (perhaps this is because I use PQescapeString). The only way to know there is an error