| From: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
|---|---|
| To: | Jiří Němec <konference(at)menea(dot)cz> |
| Cc: | Postgresql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL select |
| Date: | 2005-07-16 09:16:49 |
| Message-ID: | 1121505409.30587.24.camel@Andrea.peacock.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Am Samstag, den 16.07.2005, 09:19 +0200 schrieb Jiří Němec:
> 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?
May we see \dt please?
I'm pretty sure fieldx does not exist. Maybe you have "FieldX" or
something instead?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Morgan Lloyd | 2005-07-16 10:45:18 | Re: Nulls in timestamps |
| Previous Message | Stephan Szabo | 2005-07-16 07:36:28 | Re: PostgreSQL select |