| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: BUG? |
| Date: | 2003-11-08 14:03:06 |
| Message-ID: | Pine.LNX.4.44.0311081502010.11030-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Martin Marques writes:
> Look at the NOTICE:
>
> siprebi=> SELECT max(tprestamo.cantmaxpres) FROM tprestamo t,usuarios
> u,personas p,objetos o, tipodoc td WHERE t.cateusuario = u.cateusuario AND
> u.persona = p.codigo AND p.docnum = 23622139 AND p.tdocu = td.codigo AND
> td.nombre = 1 AND t.cateobjeto = o.cateobjeto AND o.ninventario = 29 AND
> o.uacademi = 4;
> NOTICE: Adding missing FROM-clause entry for table "tprestamo"
If you assign an alias to a table, the original table name becomes
invisible. Read the documentation.
--
Peter Eisentraut peter_e(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2003-11-08 14:07:33 | Re: BUG? |
| Previous Message | Martin Marques | 2003-11-08 13:35:49 | BUG? |