Re: Need Help In arrays

Lists: pgsql-hackers
From: Salman Razzaq <salmanrazzaq2005(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Need Help In arrays
Date: 2006-02-03 12:30:16
Message-ID: 5d13918f0602030430q271a7d1eu4896b9984a560480@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Dear Group Members,
Hi,
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?.
Thankyou.

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Salman Razzaq <salmanrazzaq2005(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Need Help In arrays
Date: 2006-02-03 14:47:49
Message-ID: 20060203144749.GB16575@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

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.

From: Salman Razzaq <salmanrazzaq2005(at)gmail(dot)com>
To: Salman Razzaq <salmanrazzaq2005(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Need Help In arrays
Date: 2006-02-07 08:12:49
Message-ID: 5d13918f0602070012v3d33481au59389b9a0973aca6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

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(at)commandprompt(dot)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.
>

From: "Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com>
To: salmanrazzaq2005(at)gmail(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Need Help In arrays
Date: 2006-02-07 11:40:53
Message-ID: BAY20-F230C0942146CB49E6D0D96F9010@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

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(at)commandprompt(dot)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/