Re: [SQL] Bug? Me or PostgreSQL.

2001-02-18 Thread Tod McQuillin
On Mon, 19 Feb 2001, Christopher Sawtell wrote: > How can this happen? > > chris=# select name from boys_names where > boys_names.number=(random()*225+1)::int4; > name > > Fred > Gunnar > Manuel > Rainer > (4 rows) It's not clear what you expected to see -- I'll guess you expected

Re: [SQL] Bug? Me or PostgreSQL.

2001-02-18 Thread Tom Lane
Christopher Sawtell <[EMAIL PROTECTED]> writes: > How can this happen? > chris=# select name from boys_names where > boys_names.number=(random()*225+1)::int4; > name > > Fred > Gunnar > Manuel > Rainer > (4 rows) Er, what's your complaint exactly? It's not obvious to me that the

[SQL] Bug? Me or PostgreSQL.

2001-02-18 Thread Christopher Sawtell
Greetings, How can this happen? chris=# select name from boys_names where boys_names.number=(random()*225+1)::int4; name Fred Gunnar Manuel Rainer (4 rows) Here is the table declaration: create table boys_names ( number serial primary key, name

[HACKERS] Re: [SQL] PL/SQL-to-PL/PgSQL-HOWTO beta Available

2001-02-18 Thread Tatsuo Ishii
I found below is very valuable. I hope this would be included in the 7.1 docs. -- Tatsuo Ishii From: Roberto Mello <[EMAIL PROTECTED]> Subject: [SQL] PL/SQL-to-PL/PgSQL-HOWTO beta Available Date: Sat, 17 Feb 2001 17:34:22 -0700 Message-ID: <[EMAIL PROTECTED]> > Hi all, > > I finishe

[SQL] speed up creation of a table

2001-02-18 Thread Alexaki Sofia
Hello, I have two questions concerning space and time required to load huge volume of data in the DBMS. To note I use JDBC interface to load the schema and data in the postgresql In order to create the tables contained in my database I use the command stmt.executeUpdate("CREATE TABLE t1