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.stehule@xxxxxxxxx> 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 <lopes80andre@xxxxxxxxx>: >> 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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) >>> To make changes to your subscription: >>> http://www.postgresql.org/mailpref/pgsql-general >>> >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
