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
