Re: [SQL] Determining if two subnets intersect

Florian Weimer <[EMAIL PROTECTED]> writes: > Is there some efficient PostgreSQL expression which is true if and > only if two subnets (given as values of type cidr) have non-empty > intersection (even if the intersection is not a CIDR network)? Maybe I'm missing something, but ISTM it's only poss

Re: [SQL] nextval on insert by arbitrary sequence

On Fri, Jul 20, 2001 at 10:13:04AM -0700, Dado Feigenblatt wrote: [...] > You kind of implied the answer to my question. > You just does it in the client instead of using back stored > functions/triggers or contrived SQL to handle that, right? That's correct. -- Henry House OpenPGP key availab

Re: [SQL] Re: When PostgreSQL compliant JDBC 2.0?

"Ed Yu" <[EMAIL PROTECTED]> writes: > ... I've been trying to get in touch with > whoever works on the postgresql jdbc driver with no luck. You're looking in the wrong mailing list. They hang out in pgsql-jdbc. regards, tom lane ---(end of broadc

Re: [SQL] How to get the server version??

On Tue, Jul 24, 2001 at 10:50:50AM -0300, Roberto Jo?o Lopes Garcia wrote: > Hi > > Is there any way, possible an SQL or pgsql command, to get the server version? > template1=# select version(); version -

[SQL] Re: Query optimizing - paradox behave

Hallo Stephan! Are there several versions of dbPG95GetIndex existing, or did you mention postgres version 7.1.2? With a little help I have killed the Problem!! Yeah, But now I trying to improve the C-code. Do You have any experience with optimizing C-Code. Are there some new miracle-like functio

Re: [SQL] how can we get total records in pg server?

Bhuvan, > the need is to get TOTAL RECORDS of all the THREE DATABASES or > atleast > TOTAL RECORDS of ONE DATABASE. I guess that many of us are confused by your question. The total records in a table are easily counted -- just use count(*). However, if your database has many tables, what signi

Re: [SQL] How to get the server version??

From: "Roberto João Lopes Garcia" <[EMAIL PROTECTED]> > Is there any way, possible an SQL or pgsql command, to get the server version? select version(); - Richard Huxton ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please

Re: [SQL] How to get the server version??

select version(); >From: Roberto João Lopes Garcia <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: [SQL] How to get the server version?? >Date: Tue, 24 Jul 2001 10:50:50 -0300 > >Hi > >Is there any way, possible an SQL or pgsql command, to get the server >version? > >Thank you > >Roberto >

[SQL] Re: position(text,text) function

Many thanks for all of the assistance on this question. I can't say I've ever seen the "a in b" syntax in postgres, but you live and learn. ;-) Thanks again. Karl. In article <[EMAIL PROTECTED]>, Karl Orbell wrote: > I'm having trouble using the position function, it's a simple built-in functi

[SQL] How to get the server version??

Hi Is there any way, possible an SQL or pgsql command, to get the server version? Thank you Roberto ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] how can we get total records in pg server?

hi all, consider the pg server with databases bhuvan uday guru the need is to get TOTAL RECORDS of all the THREE DATABASES or atleast TOTAL RECORDS of ONE DATABASE. Seems to be simple. Thankx in advance and infact i was a newbie. Regards, Bhuvaneswar.

Re: [SQL] Table scan instead of index scan

On Tue, 24 Jul 2001, [ISO-8859-1] Mário Sérgio G Antunes wrote: > I use PostgreSQL 7.1.2.4 in two servers under RedHat 7.0. > Our database has a table like that: > create table tb_client > ( >id_client varchar(32), >client_name varchar(40), >bdate date, > ... > ); > > create index

[SQL] Table scan instead of index scan

Hi, I am sure PostgreSQL is a very powerful product! I use PostgreSQL 7.1.2.4 in two servers under RedHat 7.0. Our database has a table like that: create table tb_client ( id_client varchar(32), client_name varchar(40), bdate date, ... ); create index xiftb_client on tb_client(id_cl

[SQL] Re: Query optimizing - paradox behave

Hallo! Thanks a lot to You Tom. I stared only at the user and the system time. I didn't found any C-function, with wich I could measure the whole time, so I used getrusage(). I did not recognize, that the whole time is reduced, because the User time is increased. Could that anybody explain to me?