Re: [SQL] loading array_iterator.so does not work with Postgresql

2001-09-23 Thread Oleg Bartunov
Frederick, while I have no experience with contrib/array it seems our contrib/intarray would help you. As a benefit you will get indexed access to an array Oleg On Sun, 23 Sep 2001, Frederick Klauschen wrote: > I try to load the array_iterator to find array-entries > without knowing at

Re: [SQL] outer joins strangeness

2001-09-23 Thread Alex Pilosov
On Sun, 23 Sep 2001, Stephan Szabo wrote: > On Sun, 23 Sep 2001, Alex Pilosov wrote: > > > It may be just me, or I am grossly misunderstanding syntax of outer joins, > > but I see that plans for my queries are different depending on how I place > > join conditions and sometimes even on order of

Re: [SQL] outer joins strangeness

2001-09-23 Thread Stephan Szabo
On Sun, 23 Sep 2001, Alex Pilosov wrote: > It may be just me, or I am grossly misunderstanding syntax of outer joins, > but I see that plans for my queries are different depending on how I place > join conditions and sometimes even on order of the tables. > > Example: > 1: > explain select * fro

[SQL] loading array_iterator.so does not work with Postgresql 7.0.3/7.1.3

2001-09-23 Thread Frederick Klauschen
I try to load the array_iterator to find array-entries without knowing at what position they are. Compiling worked o.k. and the psql -d databasename -f /path/array_iterator.sql worked fine. But then load /path/array_iterator.so does not work. The library-file is found, but there seems to be a pro

[SQL] How to enter lists into database.

2001-09-23 Thread Frederick Klauschen
I try to find a way to enter a list of items into my database , of which the size should be flexible. I then would like perform queries on that list in a way, that the whole list is retrieved, when the query's items are found to be in that list. Thanks for any help, Frederick ___

Re: [SQL] Bug?: Update on ancestor for a row of a child

2001-09-23 Thread Kevin Way
> The problem is: when updating a row in an ancestor table, > which is really belongs to a child, there's something wrong > with the CHECK system. Well, I believe you found one minor problem. The bigger one is still lurking in the shadows though. To duplicate it, take my previous schema, and ad

[SQL] problem loading array

2001-09-23 Thread Frederick Klauschen
__ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://arc

[SQL] outer joins strangeness

2001-09-23 Thread Alex Pilosov
It may be just me, or I am grossly misunderstanding syntax of outer joins, but I see that plans for my queries are different depending on how I place join conditions and sometimes even on order of the tables. Basically, if I mix ANSI-syntax outer joins (a left outer join b on a.id=b.id) and "wher

[SQL] Bug?: Update on ancestor for a row of a child

2001-09-23 Thread Kovacs Baldvin
Hello (mainly developer) folks! Probably Kevin really found a bug. When I saw his words in $50, I immediately started to look around his problem... You probably don't think that as a student here, in Hungary I live half a month for $50 :- So I simplified his given schema as much as I needed

[SQL] Request for book reviews/comments

2001-09-23 Thread Josh Berkus
Folks, Below are several "how-to" book reviews I intend to put up at TechDocs (with Justin's OK). The idea is to provide a list of reference books to reccomend to begineers and other developers, with the caveat that all books must be directly related to PostgreSQL in some way and the reviews wil

Re: [SQL] confounding, incorrect constraint error

2001-09-23 Thread Kevin Way
> > Below is a significantly simplified version of my schema, which > > exhibits > > the above problem. > > Unfortunately, even a simplified version of your schema would take me > some hours to understand. As your rule-setting is quite complex, my > first instinct would be to hunt for circular p