[GENERAL] List set bag support

2001-02-14 Thread Mourad EL HADJ MIMOUNE
 Hello, My name is Mourad. I have just started to use Postgres.   I seen that postgres support variable-length multi-dimensional arrays, whit built-in type or user-defined type. I want know if Postgres permits the use of set, list, and bag concepts.   Mourad,

[GENERAL] Insert into when the type is an other table

2001-03-19 Thread Mourad EL HADJ MIMOUNE
Hi,   I created a Tables : Create Table address (contry varchar(20), city varchar(20), zip_code integer),                               Create Table  person (Name  varchar(20), addr address);   I would know how I can Insert Values in person table.   note that Po

[GENERAL] the use of expressions instead of simple values in array insertion?

2001-06-07 Thread Mourad EL HADJ MIMOUNE
Hi, I encounter a problem whene I wanted use expressions to inset values in column whose values are of array type. the following example illustrates this problem: CREATE TABLE address (Num INT4, street VARCHAR, city VARCHAR, contry VARCHAR); CREATE TABLE person (name VARCHAR, add OID[]); CREATE F