Postgres Pro
Downloads
Home   >   mailing lists

Thread: Need Help In arrays

Need Help In arrays

From
Salman Razzaq
Date:
Dear Group Members,<br />  Hi,<br />         I found it difficult to use 'construct_md_array' as  i want  to  construct
an array with NULL elements included in it. How do i do that?.<br />                                    Thankyou. <br
/>

Re: Need Help In arrays

From
Alvaro Herrera
Date:
Salman Razzaq wrote:

>         I found it difficult to use 'construct_md_array' as  i want  to
> construct an  array with NULL elements included in it. How do i do that?.

Keep in mind that you can't do that in released versions (8.1 and
earlier); it's only possible in the current development branch.  If you
are using 8.2dev, see the code comment -- it's explained there.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Re: Need Help In arrays

From
Salman Razzaq
Date:
Hi,
  Thanks for replying. I am using the latest code that is 8.1.2. I look at the comments of construct_md_array function. On it, it says that NULL values are not supported. Please kindly help me out or tell me some other way.
                                                          Thankyou.



On 2/3/06, Alvaro Herrera <alvherre@commandprompt.com> wrote:
Salman Razzaq wrote:

>         I found it difficult to use 'construct_md_array' as  i want  to
> construct an  array with NULL elements included in it. How do i do that?.

Keep in mind that you can't do that in released versions (8.1 and
earlier); it's only possible in the current development branch.  If you
are using 8.2dev, see the code comment -- it's explained there.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Re: Need Help In arrays

From
"Pavel Stehule"
Date:
Hello

there isn't other way :-). If you can, use source code from cvs and compile 
postgresql.

http://www.postgresql.org/developer/sourcecode/

or you can use string array, and fictive NULL values.

Regards
Pavel Stehule

>
>Hi,
>   Thanks for replying. I am using the latest code that is 8.1.2. I look at
>the comments of construct_md_array function. On it, it says that NULL 
>values
>are not supported. Please kindly help me out or tell me some other way.
>                                                           Thankyou.
>
>
>
>On 2/3/06, Alvaro Herrera <alvherre@commandprompt.com> wrote:
> >
> > Salman Razzaq wrote:
> >
> > >         I found it difficult to use 'construct_md_array' as  i want  
>to
> > > construct an  array with NULL elements included in it. How do i do
> > that?.
> >
> > Keep in mind that you can't do that in released versions (8.1 and
> > earlier); it's only possible in the current development branch.  If you
> > are using 8.2dev, see the code comment -- it's explained there.
> >
> > --
> > Alvaro Herrera
> > http://www.CommandPrompt.com/
> > The PostgreSQL Company - Command Prompt, Inc.
> >

_________________________________________________________________
Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/