Hi Pavel, Thanks for the reply. It was exactly that that I'm looking for.
Best Regards, On Sun, Mar 6, 2011 at 3:05 PM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > 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 <lopes80an...@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 <pie...@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 >> > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
