From: | "Gregory Wood" <gregw(at)com-stock(dot)com> |
---|---|
To: | "Martina Mostert" <martina_mostert(at)gmx(dot)de> |
Cc: | "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Arrays in pgsql |
Date: | 2002-03-04 12:52:14 |
Message-ID: | 015d01c1c37b$69ec1d80$7889ffcc@comstock.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> I'm working on a plpgsql-function. I need an array of type integer. The
> Programmer's Guide says 'PL/pgSQL variables can have any SQL datatype',
> so I'd say there should also be arrays - or am I wrong?
You'd be wrong... arrays are *not* an SQL datatype. Arrays are a PostgreSQL
construct.
> monthday integer[12];
> Any suggestions?
The closest thing I can come up with is creating a simple table with an
integer array column as a template, then you can declare a variable with a
TYPE matching that table. For example:
CREATE TABLE int_array_table (int_array integer[12]);
Then you can say:
monthday int_array_table.int_array%TYPE
But to be honest, I haven't tried this, so I can't say if it works or not.
Greg
From | Date | Subject | |
---|---|---|---|
Next Message | Holger Marzen | 2002-03-04 13:26:50 | Re: copying database? |
Previous Message | Raymond O'Donnell | 2002-03-04 12:51:57 | Re: SQL question - duplicate records from join |