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
