Rodriguez Fernando <rodriguez(at)ort(dot)edu(dot)uy> writes:
> Yesterday i did a mistake executing one query, i use a column daes not
> exists in the table the result was all rows of the table.
> Platform Fedora 14 32 bits
> Version Postgresql 9.0.2
> The column id_documento not exists in t_log_modificar_deuda, this
> behavior is correct or not?
> select * from t_documento where (importe_deudor_documento >
> importe_documento) or id_documento in (select id_documento from
> result all column of t_documento.
Yes, it is. That's an outer reference to the id_documento from
t_documento, so of course the IN will succeed (assuming id_documento
isn't null and there's at least one row in t_log_modificar_deuda).
Outer references are a SQL feature that bites novices fairly often :-(
but on the other hand sub-selects would be far less useful without them.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: pedro mg||Date: 2011-05-09 18:07:25|
|Subject: BUG #6017: COPY from CSV file, WITH CSV HEADER fields order not respected|
|Previous:||From: asuffield||Date: 2011-05-09 13:03:05|
|Subject: BUG #6016: Documentation makes inappropriate reference to boolean logic|