Arrays in pgsql

From: Martina Mostert <martina_mostert(at)gmx(dot)de>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Arrays in pgsql
Date: 2002-03-04 11:28:58
Message-ID: 3C835A7A.65F39384@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hallo,
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?

Therefore I've got the following line in my code:

monthday integer[12];

But when running I always get 'ERROR: parse error at or near "["'.

Any suggestions?

Martina

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2002-03-04 11:35:56 Re: April 1
Previous Message Mark Rae 2002-03-04 11:28:20 Re: Aborting transaction on error