Re: [SQL] Rows as Columns

2003-04-01 Thread chester c young
This is obtuse, but it would work: Have a function that would dynamically build a view that has each of your type names as a column name. It could be triggered by any changes to the types table. The data table would be a left joined onto the customer table for each column. Then select from the

Re: [SQL] How can I quit this: "Unique " to my table?

2003-04-01 Thread Achilleus Mantzios
On Tue, 1 Apr 2003, Luis Mix wrote: > Hello pgsql-sql, > > When my table was create I wrote this: > > MyDatabase=# create table b_prestamo(no_inventa char(16) unique not > null, cve_area char(10), date1 date); > I need now that my table can accept repeated records, but not Null. > How

[SQL] How can I quit this: "Unique " to my table?

2003-04-01 Thread Luis Mix
Hello pgsql-sql, When my table was create I wrote this: MyDatabase=# create table b_prestamo(no_inventa char(16) unique not null, cve_area char(10), date1 date); I need now that my table can accept repeated records, but not Null. How can I do that? SomeBody can help me please? My ta