Postgres Pro
Downloads
Home   >   mailing lists

Re: array size problem - Mailing list pgsql-novice

From John DeSoi
Subject Re: array size problem
Date
Msg-id D0F77B4E-8179-4C32-806B-92FA908C824D@pgedit.com
Whole thread Raw
In response to array size problem  ("Luis Silva" <lfs12@hotmail.com>)
List pgsql-novice
Tree view 
On Jan 1, 2006, at 5:17 PM, Luis Silva wrote:

> I want to make a function in pl/pgsql with 1 argument, a char[]
> (ex. identities). Is it possible to get the size of the array


array_upper (anyarray, 1)

See http://www.postgresql.org/docs/8.1/interactive/functions-array.html




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

pgsql-novice by date:

Previous
From: "Luis Silva"
Date:
Subject: array size problem
Next
From: Steve Tucknott
Date:
Subject: Sequential Scans On Complex Query With UNION - see why this fails