From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Andre Lopes <lopes80andre(at)gmail(dot)com> |
Cc: | John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: PHP array to PlPgSQL arrat. How to? |
Date: | 2011-03-06 15:05:26 |
Message-ID: | AANLkTikcm1qUhN23bSyNZd1aZL8KXN8EN2k2vS9V4UMj@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gmail(dot)com>:
> 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
>>
>
> --
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Cia Watson | 2011-03-06 16:22:06 | Re: School teacher in need of HELP |
Previous Message | Andre Lopes | 2011-03-06 14:58:21 | Re: PHP array to PlPgSQL arrat. How to? |