Re: SQL query problem
| От | Karsten Hilbert |
|---|---|
| Тема | Re: SQL query problem |
| Дата | |
| Msg-id | 20031009233308.B2022@hermes.hilbert.loc обсуждение исходный текст |
| Ответ на | SQL query problem ("Marek Lewczuk" <newsy@lewczuk.com>) |
| Ответы |
Re: SQL query problem (many table in FROM statement and many LEFT JOIN's)
|
| Список | pgsql-general |
> fine). PG returns: ERROR: Relation "_con" does not exist
>
> This is my query:
>
> SELECT
> _CON.con_id,
Please make sure you get the quoting right regarding table
names. PostgreSQL will fold _CON into _con unless quoted
"_CON". So, it may be that you created the table with quotes
("_CON"). Now, in your query you don't use quotes and thusly
it is looking for a _con table. The simple rule of thumb is to
either always or never use quotes.
HTH,
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
В списке pgsql-general по дате отправления: