[GENERAL] restricting select statements

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

Re: [GENERAL] restricting select statements

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

[GENERAL] ISP with PostgreSQL

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

Re: [GENERAL] Checkboxes on MSAccess and PostgreSQL

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 database, if

RE: [GENERAL] ISP with 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

[GENERAL] How to cast a boolean into an int2 ?

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]

[GENERAL] How to Retrieve Just One Record ?

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

Re: [GENERAL] timestamps

[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 NULL

RE: [GENERAL] Checkboxes on MSAccess and PostgreSQL

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:

Re: [GENERAL] ISP with PostgreSQL

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 using

[GENERAL] Permission to create Postgres Views

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 am a

[GENERAL] character limit on db names in PGSQL or what?

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