Hello
look on array_lower and array_upper functions
http://www.postgresql.org/docs/8.2/static/functions-array.html
for one dimensional arrays - select array_upper(var,1) - array_lower(var,1)
Regards
Pavel Stehule
2011/3/6 Andre Lopes <lopes80andre@gmail.com>:
> Hi,
>
> Just another question about this subject.
>
> It is possible to compare if these 3 PlpgSQL arrays have the same
> number of elements? How to get the number of elements of an PLpgSQL
> array?
>
> NOTICE: file types: {image,image,image,image,image}
> NOTICE: file details: {type,width,height,html_width_height,mime}
> NOTICE: values: {jpg,343,515,"width=\"343\" height=\"515\"",image/jpeg}
>
> Best Regards,
>
>
>
>
>
>
> On Sat, Mar 5, 2011 at 10:44 PM, John R Pierce <pierce@hogranch.com> wrote:
>> On 03/05/11 11:22 AM, Andre Lopes wrote:
>>>
>>> Hi,
>>>
>>> I need to transform an PHP array to an PlPgSQL array. The PHP array is
>>> like this:
>>
>> in a relational database, it would be far better to store that sort of thing
>> as a table, so you can use relational operations on it.
>>
>> your example structure would fit nicely into a table like...
>>
>> CREATE TABLE images (
>> id integer primary key,
>> base64 text,
>> image_type text,
>> width integer,
>> height integer,
>> mime text );
>>
>> and use a view to construct the html_width_height value as it contains
>> redundant data
>>
>> CREATE VIEW images_html (id, html_width_height)
>> as select id, 'width="'||cast(width as text)||'" height="'||cast(height
>> as text)||'"' from images;
>>
>>
>>
>>
>> btw, if that base64 field is in fact the binary image, I would instead
>> change that to `image bytea` and store the image in binary.
>>
>>
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
