| 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: | Whole Thread | Raw Message | 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 |