Обсуждение: Problem with an Empty Column

Good Morning list, I am new in the PostgreSQL list, and i have a problem with a query because i have an empty column in
aempty table and i compare this empty column with a column what have values in other table i use an LEFT OUTER JOIN and
workswell, but when i filled the empty table with data and compare again the query give me the same result than if the
tablewas empty, here is the code of my query:<br />SELECT supplierbill_tbl.id<br />FROM supplierbill_tbl <br />LEFT
OUTERJOIN agrouptransacc_tbl<br />ON supplierbill_tbl.id > agrouptransacc_tbl.splbillid<br /><br />--<br />Diego I.
HidalgoD. 

On Tue, Mar 10, 2009 at 11:41 PM,  <hidura@gmail.com> wrote:
> Good Morning list, I am new in the PostgreSQL list, and i have a problem
> with a query because i have an empty column in a empty table and i compare
> this empty column with a column what have values in other table i use an
> LEFT OUTER JOIN and works well, but when i filled the empty table with data
> and compare again the query give me the same result than if the table was
> empty, here is the code of my query:
> SELECT supplierbill_tbl.id
> FROM supplierbill_tbl
> LEFT OUTER JOIN agrouptransacc_tbl
> ON supplierbill_tbl.id > agrouptransacc_tbl.splbillid

I think we need a more complete example.  Note you can generate rows
in a table with generate_series() pretty easily for testing.