Re: [GENERAL] null and =

At 10:39 PM 05-12-1999 -0500, Mike Mascari wrote: >I would just do: > >SELECT users.usr_id, users.usr_login FROM users WHERE NOT EXISTS > (SELECT wm_accounts.usr_id FROM wm_accounts WHERE > wm_accounts.usr_id = users.usr_id); OK, my current query is select usr_id,usr_login from users where usr_i

[GENERAL] database GUI library for C,C++

Hello! I try to make a PostgreSQL based GUI aplication. I find a lot of GUI libraries, but none of them have 'high level' classes for accessing and displaying dates from databases in a more convenient mode. (like TTable, TDBGrid in Delphi) Is there something like that? Thanks, Karesz. *

[GENERAL] GIS and PostgreSQL ?

Does anybody know some GIS software used with PostgreSQL ? Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] Web site: www.sopac.org.fj

Re: [GENERAL] procmail w/ PG.

hi, That looks promising. Any idea where the mail reformatted 'formail' gets the input email? From STDIN? J Ed Loehr wrote: > "Jason C. Leach" wrote: > > > :0 > * ^Subject:.*Digest > |formail +1 -d -s procmail > > This sounds like a task well-suited to perl regular expressions wi

RE: [GENERAL] Oft Ask: How to contribute to PostgreSQL?

Does anybody know about some GIS or GPS software using PostgreSQL outside GRASS? Thanks. Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] Web site: www.sopac.org.fj

Re: [GENERAL] null and =

Lincoln Yeoh wrote: > At 04:59 PM 05-12-1999 -0500, Mike Mascari wrote: > >Instead, I would use a correlated subquery with an EXISTS/NOT EXISTS test > >against the criteria for which you are searching: > > > >SELECT t1.a, t1.b FROM dummy t1 > >WHERE EXISTS (SELECT t2.a FROM dummy t2 WHERE t1.a =

Re: [GENERAL] Oft Ask: How to contribute to PostgreSQL?

On Sun, 5 Dec 1999, Jason C. Leach wrote: > hi, > > Is PG done in C or C++? C Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org

Re: [GENERAL] Oft Ask: How to contribute to PostgreSQL?

hi, Is PG done in C or C++? -- . . Jason C. Leach .. University College of the Cariboo ... [EMAIL PROTECTED] .. http://www.ocis.net/~jcl . Debian!Linux!

Re: [GENERAL] null and =

At 04:59 PM 05-12-1999 -0500, Mike Mascari wrote: >Instead, I would use a correlated subquery with an EXISTS/NOT EXISTS test >against the criteria for which you are searching: > >SELECT t1.a, t1.b FROM dummy t1 >WHERE EXISTS (SELECT t2.a FROM dummy t2 WHERE t1.a = t2.a) > > I've got two table

[GENERAL] Oft Ask: How to contribute to PostgreSQL?

Due to a recent thread started on pgsql-hackers, I'm posting this to the lists. Vince is planning on putting in appropriate links for some of this, and, Bruce, can we maybe put it into the FAQ? I'm not an English major, so this is more techinese then anything else...or, a rambling of an un-orde

Re: [GENERAL] Buggered Sequence

On Sat, 4 Dec 1999, Ross J. Reedstrom wrote: >Jason - >Jesse's sugestion should work, but there's a setval() function for >this exact use: > >SELECT setval('people_id_seq',44); > >I usually use it like this: > >SELECT setval('"Experiments_ExptID_seq"',max("ExptID")) from "Experiments"; > >That a

Re: [GENERAL] null and =

Mike Mascari wrote: > > I would avoid using the INTERSECT/EXCEPT code since the query rewriter > rewrites these to IN clauses which cannot use indexes. As soon as the tables > grow beyond more than a couple hundred rows, the statment becomes unusable. > Instead, I would use a correlated subquery

Re: [GENERAL] null and =

Slavica Stefic wrote: > Hello, > > is null = null true or also null ? NULL = NULL is also NULL (or more explicity, UNKNOWN, implemented as NULL). Since NULL means "unknown/not applicable" we don't know whether two "unknowns" are, in fact, equal, and that is what the standard says - at least acco

Re: [GENERAL] procmail w/ PG.

"Jason C. Leach" wrote: > I'l like procmail to filter out the To, From, Date, Subject, Body and > complete header of the email. Then either stick it in a DB, or pass > that info to a Perl script to stick in in the DB. > > Anyone know of such a script? Or an example I can work with? Caveat empto

[GENERAL] procmail w/ PG.

hi, I seem to have found a good solution for getting email into a Pg db, only problem is I'm not good enough with procmail scripts to do it. I'l like procmail to filter out the To, From, Date, Subject, Body and complete header of the email. Then either stick it in a DB, or pass that info to a P

Re: [GENERAL] null and =

Slavica Stefic wrote: > is null = null true or also null? A null value represents either the absence of data or an unknown value. A null value is not the same as a zero or a blank. Thus two tuples with null values are never the same and can not be joined. > it appears that two null records a

[GENERAL] null and =

Hello, is null = null true or also null ? more precisely I have this kind of situation in a mission critical project and I'm,sadly, not an expert in SQL. But until now I used null values with a specific meaning in my database, and I didn't knew that I would come in this situation: =>create tabl

[GENERAL] PostgreSQL and Java

This message was sent from Geocrawler.com by "USSL" <[EMAIL PROTECTED]> Be sure to reply to that address. Subject: Request for help on PostgreSQL and JBuilder Hi members, Is there someone who can help me in establishing connectivity between PostgreSQL and JBuilder using JDBC driver ? My env

Re: [GENERAL] memory

Bruce Momjian <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] said: > 1) Can someone explain how postgreSQL uses memory so that I can > understand > what I should be doing here. > BTW, I am running postgres with -B 884. Can someone also explain how > postgres uses shared mem so that I can have a cl

Re: [GENERAL] PostgreSQL 6.5.3 on SuSE 6.1

> Hi list members: > I am currently using PostgreSQL 6.4.2 on SuSE 6.1. This version came with > the SuSE disks. Recently, I downloaded and compiled the source from the > pgsql ftp site, but postgres does not run and says that a file called > libreadline.so is needed to run. This file is not on