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
>
