Re: [SQL] Problem with an Empty Column

2009-03-10 Thread Scott Marlowe
On Tue, Mar 10, 2009 at 11:41 PM, 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 w

[SQL] Problem with an Empty Column

2009-03-10 Thread hidura
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 d

Re: [SQL] Inherits is not encouraged?

2009-03-10 Thread Karsten Hilbert
On Mon, Mar 09, 2009 at 07:55:35PM -0400, Tom Lane wrote: > Emi Lu writes: > > (1) Is possible that I could change the column of a table that is > > defined by Inherits? > > > e.g., t1(col1, col2, col3); create table tx(colx) Inherits (t1) > > I'd like to get tx shown as (col1, colx, col2, col3