Re: PHP array to PlPgSQL arrat. How to?

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(at)hogranch(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>