Re: Query does not work: parse ERROR, Re: [SQL] How to enter lists into database: Problems with solution.

2001-09-26 Thread Josh Berkus
Frederick, > I am really sorry to bother you again and I promise > to buy a book after this problem is solved and > stop asking these "beginners'" questions. Nah, this one wasn't a beginners question. Intermediate, maybe. > But the last example-Query you sent me does not > work, it produces: >

Query does not work: parse ERROR, Re: [SQL] How to enter lists into database: Problems with solution.

2001-09-26 Thread Frederick Klauschen
Hi Josh, I am really sorry to bother you again and I promise to buy a book after this problem is solved and stop asking these "beginners'" questions. But the last example-Query you sent me does not work, it produces: ERROR: parser: parse error at or near "(" and I am sure, I entered it correctl

Re: [SQL] How to enter lists into database: Problems with solution.

2001-09-26 Thread Josh Berkus
Frederick, > "Mary Stuart" correctly. But such a query also > seems to get results that contain only one > of the search_attributes. > e.g. a 32 "Peter Smith" who e.g. just has an entry > 24 32 "hair" "brown" (and no mice hobby) is also > found. > I need to get only results that match the search

Re: [SQL] How to enter lists into database.

2001-09-24 Thread Oleg Bartunov
He is probably thinking about arrays. contrib/array, contrib/intarray could be worth to see. Oleg On Mon, 24 Sep 2001, Josh Berkus wrote: > Mr. 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

Re: [SQL] How to enter lists into database.

2001-09-24 Thread Josh Berkus
Mr. 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, Ca

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