| From: | Jiří Němec <konference(at)menea(dot)cz> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | PostgreSQL select |
| Date: | 2005-07-16 07:19:08 |
| Message-ID: | 259008421.20050716091908@menea.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
There's a problem with PostgreSQL 8.0.3 SELECT. All tables exist, all
columns exist, I have no idea where's the problem :/ PostgreSQL
reports this error: ERROR: relation "fieldx" does not exist...
SELECT fieldx.field_id, COUNT(optionx.option_id) AS field_options
FROM c_custom_fields AS fieldx, j_product_groups_fields AS join_table
LEFT JOIN c_custom_fields_options AS optionx ON optionx.field_id = fieldx.field_id
WHERE fieldx.field_id = join_table.field_id AND join_table.group_id = 10
GROUP BY fieldx.field_id
ORDER BY fieldx.field_id
Any clues?
--
Jiří Němec, ICQ: 114651500
www.menea.cz - www stránky a aplikace
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2005-07-16 07:36:28 | Re: PostgreSQL select |
| Previous Message | Geir Pedersen | 2005-07-16 07:07:51 | Lost main database directory but not tablespace holding the database - how to recover? |