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

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:

[SQL] PARSER ERROR

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,

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

Hi Frederick, On Wed, 26 Sep 2001 19:08:59 + (UTC), [EMAIL PROTECTED] (Frederick Klauschen) wrote: 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

Re: [SQL] Subquery with IN or EXISTS

Hi A., On 26 Sep 2001 07:24:41 -0700, [EMAIL PROTECTED] (A. Mannisto) wrote: Hello, does anybody know why this: SELECT * FROM tab WHERE col1 IN (SELECT col2 FROM TAB2) equals this: SELECT * FROM tab WHERE EXISTS (SELECT col2 FROM TAB2 WHERE col1 = col2) but this: SELECT * FROM tab WHERE col1

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

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 same

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

This should be really easy to implement in a function yourself. And I don't think there is already something similar in pgsql. == Wei Weng Network Software Engineer KenCast Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Frederick

Re: [SQL]plpgsql function case statement

Peter Schmidt wrote: I'm having trouble finding the best solution for the following plpgsql function. The function does the following: Hi, I post in this mailing list for the first time. :-) I think your pl/pgsql function runs properly, but there is likely to exist another SQL pattern. In

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

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 completely.

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

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 correctly.