From: | "Gyozo Papp" <pgerzson(at)freestart(dot)hu> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | array dimension |
Date: | 2001-05-13 10:40:09 |
Message-ID: | 00eb01c0db99$2aac7b80$0c4ac5d5@jaguar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I have a couple of question related to array dimensions.
1. is there a function to get the the highest avaiable index for an array?
I found the function array_dims which returns text (ie: '[1:5]'). Should I scan this returning value to extract what I need?
2. is there a function (or operator) to append new values to the end of an array? (something like || for strings)
3. is there a function (or operator) to merge 2 arrays into one or append the one to the end of the other?
I know this could be done by writing some function, but - maybe - these are already implemented.
Thank you for any suggestion:
Papp Gyozo
- pgerzson(at)freestart(dot)hu
From | Date | Subject | |
---|---|---|---|
Next Message | Renaud Thonnart | 2001-05-13 13:28:48 | table inheritance |
Previous Message | Simon Crute | 2001-05-13 10:21:20 | Re: case sensitivity |