[SQL] PARSER ERROR persists ....

2001-09-27 Thread Frederick Klauschen
Hi, I have tried Carl's suggestion, but it does not make a difference and the same ERROR: parser: parse error at or near "(" results. I have rebuilt and reinstalled Version 7.1.3, but still the same. No compilation or installation errors are reported and simple statements seem to work properly. I

[SQL] PARSER ERROR

2001-09-26 Thread Frederick Klauschen
The commas did not get cut off and I think I did not make any other mistakes either. Is it also possible that the parser does not work properly? Thanks, Frederick Here is what happened again: ERROR: parser: parse error at or near "(" when running : > SELECT people.people_id, people.name, >

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

[SQL] is it possible to get the number of rows of a table?

2001-09-26 Thread Frederick Klauschen
I would like to compare the number of rows of one table and of another and use it in a query like this: SELECT * FROM WHERE "number of rows of table " EQUALS "number of rows of table " i.e. I only want get a query result if the tables have the s

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

[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