At 11:53 28/09/00 +1000, Christopher Smith wrote:
>
>
>All,
>
>I don't normally do this but someone has just sent a virus to the list -
Virus:
>VBS_KAKWORM.A.
>Pls check your systems for this virus (don't know the exact name of the file,
>but the virus is above).
>If its fake, sorry for any inconv
Tim Kientzle <[EMAIL PROTECTED]> writes:
> > I'm finding that ... my CPU spends about 60% of the time in JDBC, and about
> > 40% of the time in the postmaster backend.
> > (Each query takes 2 msec on my machine, RH Linux 6.2, 733 MHz Intel, w/
> > lots of memory.)
>
> This doesn't sound too bad
ignore me
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Bob Zatolokin wrote:
> I have a such task:
>
> 1. table USERS
> 2. table DEPARTMENTS
> - where each DEPARTMENT needs to store LIST of USERS in it
> 3. table FIRMS
> - where each FIRM needs to store LIST of USERS in it
> 4. table EVENTS
> - and where each EVENT needs to store LIST of _MEMBERS_
Hi,
[ deletia ]
> If you want, I can send you the sources: they compile quite clean
> on my RedHat 6.1 box with PGSQL 7.0.x.
Thank you, that would be very much appreciated. Is there not some way to
bind to the UNIX hashing functions used in passwords, etc.?
[ deletia ]
Regards,
*
[EMAIL PROTECTED] wrote:
> select * from test1, test2 where test1.id=test2.id
>
>
> but I need:
>
> test1.id | test1.value | test2.id | test2.value
> ---
> ...
>
> because I dont want to access the fields by index but by name!!!
>
My solution would be
It does not work !
I have compiled the sources under WinNT with cygnus tools.
This has functioned perfect, then i start the ipc-deamon
and the postmaster with -i option - It look like that all would
be ok, but then i try to connect do the database by psql, pgaccess and
over the jdbc - bridge - al
Hello there!
how do I get the tablenames in an resultset from an query like this:
imagine two tables with columns named id and value
test1:
id | value
1 | hello
2 | goodbye
test2:
id | value
1 | gunter
2 | heinz
select * from test1, test2 where test1.id=test2.id
Andrew Gould wrote:
>
> I have a file of data that is tab delimited, with text
> fields enclosed by quotation marks.
>
> I know I can use the copy command to load the data;
> and that tab delimited is the default. How do I tell
> Postgres to remove the quotation marks?
It is probably easiest t
I have a such task:
1. table USERS
2. table DEPARTMENTS
- where each DEPARTMENT needs to store LIST of USERS in it
3. table FIRMS
- where each FIRM needs to store LIST of USERS in it
4. table EVENTS
- and where each EVENT needs to store LIST of _MEMBERS_ - USERS or
DEPARTMENTS or FIRMS in it
Tom your right.
I take a detailed look at it and it fails exactly at 2^31 .
2^31-1 = 2147483647 --> 2147483647
2^31= 2147483648 --> -2147483648
2^31+1= 2147483649 --> -2147483647
.
10^10--> 1410065408
10^12--> -727379968
...
But how could
11 matches
Mail list logo
