[EMAIL PROTECTED] writes:
> Hi there,
>
> This is Sanjay from Dublin, Ireland. I have a query related to JDBC.
>
> In the web based application we have designed we have used Oracle 8i to
> store the data and Java as a front end.
>
> When a user enters some description against a field containi
On Mon, Oct 08, 2001 at 07:31:36PM -0700, Mike Judkins wrote:
> Im trying to insert a record with a php script. I insert a NULL value
> to get my auto increment unique key to automatically populate as
> usual. Then I want to be able to insert another value in this same row
> which is a URL. This U
The COUNT tells me how many times a particular combination of source IP,
destination IP, and service appears in the logs. The ORDER BY puts it in
decending order, and the LIMIT only shows me the top 25/50/etc. entries.
It works like I want it to - I'm just checking to see if this is the most
eff
Mike,
Perhaps you could just insert the url into the record and then
use a string function to return "url"+"id" when needed. This would
eliminate the extra insert and save space in the row.
Dale
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent
Jeff Davis <[EMAIL PROTECTED]> writes:
> I was wondering is there is a good method to make a database field a
> pointer, similar to C. Here is an example I made up of why this could be
> useful:
> Suppose I have a table 'coworkers' with 2 email address fields: work_email
> and home_email. It w
[EMAIL PROTECTED] (Mike Judkins) writes:
> to get my auto increment unique key to automatically populate as
> usual. Then I want to be able to insert another value in this same row
> which is a URL. This URL is basically a path plus a filename which I
> want to have the exact same name as the un
try this:
http://gborg.postgresql.org
-Nick
-
Nick Fankhauser
Business:
[EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765.962.9788
doxpop - Court records at your fingertips - http://www.doxpop.com/
Personal:
[EMAIL PROT
> I started looking at the trigger support in PostgreSQL and found what I
> needed except I'm not sure how to write the "body" of the trigger. In
> Oracle I write PL/SQL but it seems I may have to write C code on the
> PostgreSQL side. Is this true? Is there a PostgreSQL procedural language
> t
I was wondering is there is a good method to make a database field a
pointer, similar to C. Here is an example I made up of why this could be
useful:
Suppose I have a table 'coworkers' with 2 email address fields: work_email
and home_email. It would be useful to have another fie
On Tue, 9 Oct 2001, Tommy wrote:
> >From what I understand they went out of business. I have not seen the site
> morrored anywhere.
>
> I wonder what this means for the future of PostgreSQL?
You must be new here 'cuze this has been covered many times in the
last few weeks.
PostgreSQL is not now
just add a unique constraint on the things you want to be unique...
On Wed, 10 Oct 2001 14:37:09 -0600, Glenn Sullivan <[EMAIL PROTECTED]>
wrote:
> Greetings,
>
> I need to check a table to see if an item already exist in the table.
> It if does not, then I want to add it. Unfortunately, multip
CREATE TABLE coworkers (
id serial PRIMARY KEY,
name varchar(63)
);
CREATE TABLE email_types (
type VARCHAR(10) PRIMARY KEY
);
INSERT INTO email_types VALUES ('home');
INSERT INTO email_types VALUES ('work');
CREATE TABLE emails (
owner INTEGER REFERENCES coworke
You'll need to use createlang to add the handler.
IIRC, it's createlang
On Tue, 9 Oct 2001, Kevin HaleBoyes wrote:
> I'm creating a function (for use in a trigger) from the example in the
> documentation and encountered an error. If I type the following at
> the psql prompt (database and us
> Rob Arnold wrote:
>
> > Look at $db->errstr That has the text version of the error code.
> >
> > --rob
Yes, but I want to know about the codes, not the text. If the codes exist,
they are easier to work with than the text.
-Fran
---(end of broadcast)-
David Link wrote:
Just, reading it and I always enter these kind of queries like:
select i.isbn,
t.vendor,
i.store,
i.qty
from bk_inv i,
bk_title t
where
t.vendor = '01672708' and
i.isbn = t.isbn;
Don't know if it makes a difference but I
Has anyone heard any more about this problem? I also haven't gotten anything
from pgsql-general since Oct. 1. The other lists seem to be working fine for
me.
I tried re-subscribing, plus sending an e-mail to pgsql-general-admin. The
re-subscribe seemed to go normally and successfully, but I st
On Wed, 10 Oct 2001 [EMAIL PROTECTED] wrote:
> Just to keep things in perspective, how large are your current databases, and
> what do you or the company consider to be a signficant length of time? Right
> now I have a development database with just a few thousand records of test data,
> and v
Greetings,
I need to check a table to see if an item already exist in the table.
It if does not, then I want to add it. Unfortunately, multiple processes
(Solaris system) can be running at the same time. Sometimes, one process
checks to see if an item exist and it does not. At the same time ano
On Wed, 10 Oct 2001, David. E. Goble wrote:
> I am lazy. I which to write some c console/text programs to interface
> with postgresql. Are there any tools/utilities, to help make the data
> entry/display screens...?
David,
ncurses-5.2.
Rich
Dr. Richard B. Shepard, President
Hi,
> Has anyone heard any more about this problem? I also haven't gotten
> anything from pgsql-general since Oct. 1. The other lists seem to be
> working fine for me.
I got since about one hour mails to an old account, which I disabled months
ago.
Perhaps someone took an old backup?
Ciao
I want to design some (a significant number of) views able to select records
from various tables for, say, current_client_account_number, which I would
like to store/set in a table (not in a variable). Creating a temp table for
storing these current_client_account_number would not help, because an
Hello, we're installing PostGreSQL 7.1.3 on a RH 7.1 system and we need
the --with-python option. The ./configure step works fine, but gmake fails on
the first occurence of an #include . We added a
- --with-includes=/path/to/Python/includes, but doesn't seem to solve the
problem. What else sho
I'm new to PG but this just seems wrong. Can someone take a look:
.---. .---.
| bk_inv| | bk_title |
|---| |---|
| isbn |<--->| isbn |
| store | | vendor|
| qty | | |
| week | `-
I'm running a DB query on a database of firewall log entries (right now
around 700k rows). What I want to do is pull out some common entries, as
well as the number of times that they occur in the table.
Right now, I'm doing a query like:
select source,destination,service,count(*) FROM logs WHER
Please ignore if this is a resend, but I got an error message on my mail that
was unreadable in my mail reader.
We are install PostGreSQL 7.1.3 on a RH 7.1 system with python. ./configure
works fine, but gmake fails on the first file that has a #include
with a file not found error. We've trie
Hello,
I get the following error
pl=# select * from person where id !=-1;
ERROR: Unable to identify an operator '!=-' for types 'int8' and 'int4'
You will have to retype this query using an explicit cast
pl=# select * from person where id =-1;
id | name | last_update_time
+--
I'm a bit confused about the current state of error codes in Pg. The
docs and
the mailing list archives seem to indicate that this is a TODO item,
however,
at least when using Perl with DBD::Pg, when I call $db->err() or examine
$DBI::err I get a number back. For instance, 7 if I try to insert
27 matches
Mail list logo
