Re: [SQL] Another question about composite types

2006-11-13 Thread imad
3 de novembro de 2006 14:46 Para: [EMAIL PROTECTED]; pgsql-sql@postgresql.org Assunto: Re: [SQL] Another question about composite types > CREATE TYPE t_salary AS (Value numeric(10,2), Validity date); > CREATE TABLE employee (id int, name varchar(30), salary t_salary[]); > > That is,

RES: [SQL] Another question about composite types

2006-11-13 Thread Rodrigo Sakai
: Re: [SQL] Another question about composite types > CREATE TYPE t_salary AS (Value numeric(10,2), Validity date); > CREATE TABLE employee (id int, name varchar(30), salary t_salary[]); > > That is, I need an array of composite type and searching on google I found > that is impossib

Re: [SQL] Another question about composite types

2006-11-13 Thread Richard Broersma Jr
> CREATE TYPE t_salary AS (Value numeric(10,2), Validity date); > CREATE TABLE employee (id int, name varchar(30), salary t_salary[]); > > That is, I need an array of composite type and searching on google I found > that is impossible to do it! Is it really impossible? Anyone have do it ? Why

[SQL] Another question about composite types

2006-11-13 Thread Rodrigo Sakai
  Hi, I need to create a table like:     CREATE TYPE t_salary AS (     Value numeric(10,2),     Validity date   );     CREATE TABLE employee ( id int, name varchar(30), salary t_salary[]   );       That is, I need an array of composite type and searching on goog