I'm working with JDBC and if I issue a broad SELECT statement, with a
good amount of records (2000) it takes quite a while to execute the
query and send the results back, even up to a minute, when I only want
about the first 100 records. If I restrict the search, it is satisfied
in a much more rea
> I'm working with JDBC and if I issue a broad SELECT statement, with a
> good amount of records (2000) it takes quite a while to execute the
> query and send the results back, even up to a minute, when I only want
> about the first 100 records. If I restrict the search, it is satisfied
> in a muc
I am going to be working with a database with a lot of rather
large text fields in it. To do some profiling, I have hacked up an
IRC bot to submit messages into a database. I cannot seem to get any
of my queries to use the indexes I create on the msg field--is there
something specific I
Hi all,
Is anybody know an ISP which provided PostgreSQL access ? I'm developping
a
powerfull solution for Ebusiness using Linux RedHat 5.2 and PostgreSQL
6.4.2. But
I can't find any ISP running PostgreSQL, they all works with MySQL.
Porting to this database or other, is not so difficult becaus
> "s" == strawman <[EMAIL PROTECTED]> writes:
s> I'm trying to create a column that defaults to the current time and date. I
s> tried the SQLServer like syntax below but potgresql choked:
s> CREATE TABLE clicks (
s> avo_userid varchar (10) NOT NULL ,
s> link_id int NOT NULL ,
s> the_t
Jose' Soares wrote:
> Valerio Santinelli wrote:
> >
> > First of all.. thanks to everybody for helping me out witht the
> > "sequence" stuff. :)
> >
> > I've got another questions for you dudes. When using a CheckBox in a
> > Form written in MSAccess that's related to a table in a
> > PostgreSQL
Yea. Check out Epoch Internet, http://www.eni.net, 1-888-77-EPOCH,
I think they offer PostgreSQL. You'll probably have to call to find
out, I don't remember anything on the web page.
DwD
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> Gilles Da
How do I cast a boolean into an int2 ?
I want to do something like:
INSERT INTO test SELECT id, (demo='t') from temp;
but the second field isn't a boolean in the "test" table but an int2.
--
C'ya!
Valerio Santinelli a.k.a. TANiS
[[EMAIL PROTECTED]]+:+[http://www.mediacom.it/~tanis]
hostme.com doesn't do dialup access, but does web hosting, and provides a
choice of mysql or postgresql free with any option. they (we, actually
*grin*) work with redhat linux/gnu systems.
check it out if you want: www.hostme.com
no big deal if not. =)
-tcl.
[EMAIL PROTECTED]
On Wed, 24 Feb
Hi.
I'd like to do
select * from mytable
but just get one record. I don't even care which record.
Any ideas ?
Thanks.
--
The day is short, and the work is great, | Aharon Schkolnik
and the laborers are lazy, and the reward| [EMAIL PROTECTED]
is great, and the Master o
[EMAIL PROTECTED] ha scritto:
> I'm trying to create a column that defaults to the current time and date. I
> tried the SQLServer like syntax below but potgresql choked:
>
> CREATE TABLE clicks (
> avo_userid varchar (10) NOT NULL ,
> link_id int NOT NULL ,
> the_time timestamp NOT
I defined my Access boolean fields as int2 in Postgres. This, in
combination with removing the "Bools as Char" flag in the ODBC driver
appears to work. However, I have not been able to much testing.
-Original Message-
From: Valerio Santinelli [SMTP:[EMAIL PROTECTED]]
That's the same thing I did today to get rid of the boolean problem. Now I've
got another one ;)
I want to use my data contained in the table filled with boolean stuff and I'd
like to convert all the booleans to int2. I know there's a way to do that by
doing something like:
INSERT INTO mynewtable
I wrote a function that takes a boolean parameter and returns int2.
-Original Message-
From: Valerio Santinelli [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, February 24, 1999 1:10 PM
To: Michael Davis
Cc: [EMAIL PROTECTED]
Subject:
We offer PostgreSQL services...see http://www.hub.org/prices.html, and
note that all prices are in Canadian Dollars...
On Wed, 24 Feb 1999, Gilles Darold wrote:
> Hi all,
>
>
> Is anybody know an ISP which provided PostgreSQL access ? I'm developping
> a
> powerfull solution for Ebusiness usi
Not yet received anything, so, i repost my question...
I'm sure this is a small small question... :-)
Thanks in advance to the lightman :-)
A+
On Wed, 24 Feb 1999 [EMAIL PROTECTED] wrote:
> Dear Benjamin,
>
> I have recently noticed your posting on the postgres newsgroup.
>
> At present, I
had a db named: prysm_shreveport
with one table named 'shreveport'
came back later and did:
createdb prysm_shreveport2
psql -e prysm_shreveport2 < shreveport2.sql --> which creates table
'shreveport2'
then:
psql prysm_shreveport2
which to my sup
Kevin -
Seems to be fixed w/ 6.4.2:
$ createdb createdb prysm_shreveport
$ createdb createdb prysm_shreveport2
$ psql prysm_shreveport
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
type \? for help on slash commands
t
18 matches
Mail list logo
