pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedAdding null values to arrays
5+ messages / 3 participants
[nested] [flat]
* Adding null values to arrays
@ 2004-09-07 22:20 Kathy Smith <ksmith@lanl.gov>
2004-09-10 21:26 ` Re: Adding null values to arrays Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: Kathy Smith @ 2004-09-07 22:20 UTC (permalink / raw)
To: pgsql-interfaces
I understand from searching around that it is on the "To Do" list to allow
null values in arrays. Can anyone tell me where this is in the
implementation process and/or if there is a work around?
Thanks, Kathy
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Adding null values to arrays
2004-09-07 22:20 Adding null values to arrays Kathy Smith <ksmith@lanl.gov>
@ 2004-09-10 21:26 ` Bruce Momjian <pgman@candle.pha.pa.us>
2004-09-10 22:32 ` Re: Adding null values to arrays Joe Conway <mail@joeconway.com>
0 siblings, 1 reply; 5+ messages in thread
From: Bruce Momjian @ 2004-09-10 21:26 UTC (permalink / raw)
To: Kathy Smith <ksmith@lanl.gov>; +Cc: pgsql-interfaces
Kathy Smith wrote:
> I understand from searching around that it is on the "To Do" list to allow
> null values in arrays. Can anyone tell me where this is in the
> implementation process and/or if there is a work around?
Uh, no one is implementing it and there is no workaround. :-)
If you are considering coding it, read the developers FAQ>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Adding null values to arrays
2004-09-07 22:20 Adding null values to arrays Kathy Smith <ksmith@lanl.gov>
2004-09-10 21:26 ` Re: Adding null values to arrays Bruce Momjian <pgman@candle.pha.pa.us>
@ 2004-09-10 22:32 ` Joe Conway <mail@joeconway.com>
2004-09-10 23:58 ` Re: Adding null values to arrays Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: Joe Conway @ 2004-09-10 22:32 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Kathy Smith <ksmith@lanl.gov>; pgsql-interfaces
Bruce Momjian wrote:
> Kathy Smith wrote:
>>I understand from searching around that it is on the "To Do" list to allow
>>null values in arrays. Can anyone tell me where this is in the
>>implementation process and/or if there is a work around?
>
> Uh, no one is implementing it and there is no workaround. :-)
>
> If you are considering coding it, read the developers FAQ>
>
FWIW, in the past I've "made noises" about implementing support for NULL
array elements. I couldn't find the time to do it for 8.0, but I'm
hopeful that I will be able to find the time to do it for 8.1. However
if someone else wants to have at it, don't let me get in the way ;-)
Joe
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Adding null values to arrays
2004-09-07 22:20 Adding null values to arrays Kathy Smith <ksmith@lanl.gov>
2004-09-10 21:26 ` Re: Adding null values to arrays Bruce Momjian <pgman@candle.pha.pa.us>
2004-09-10 22:32 ` Re: Adding null values to arrays Joe Conway <mail@joeconway.com>
@ 2004-09-10 23:58 ` Bruce Momjian <pgman@candle.pha.pa.us>
2004-09-21 15:32 ` Re: Adding null values to arrays Kathy Smith <ksmith@lanl.gov>
0 siblings, 1 reply; 5+ messages in thread
From: Bruce Momjian @ 2004-09-10 23:58 UTC (permalink / raw)
To: Joe Conway <mail@joeconway.com>; +Cc: Kathy Smith <ksmith@lanl.gov>; pgsql-interfaces
Joe Conway wrote:
> Bruce Momjian wrote:
> > Kathy Smith wrote:
> >>I understand from searching around that it is on the "To Do" list to allow
> >>null values in arrays. Can anyone tell me where this is in the
> >>implementation process and/or if there is a work around?
> >
> > Uh, no one is implementing it and there is no workaround. :-)
> >
> > If you are considering coding it, read the developers FAQ>
> >
>
> FWIW, in the past I've "made noises" about implementing support for NULL
> array elements. I couldn't find the time to do it for 8.0, but I'm
> hopeful that I will be able to find the time to do it for 8.1. However
> if someone else wants to have at it, don't let me get in the way ;-)
OK, great.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Adding null values to arrays
2004-09-07 22:20 Adding null values to arrays Kathy Smith <ksmith@lanl.gov>
2004-09-10 21:26 ` Re: Adding null values to arrays Bruce Momjian <pgman@candle.pha.pa.us>
2004-09-10 22:32 ` Re: Adding null values to arrays Joe Conway <mail@joeconway.com>
2004-09-10 23:58 ` Re: Adding null values to arrays Bruce Momjian <pgman@candle.pha.pa.us>
@ 2004-09-21 15:32 ` Kathy Smith <ksmith@lanl.gov>
0 siblings, 0 replies; 5+ messages in thread
From: Kathy Smith @ 2004-09-21 15:32 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; Joe Conway <mail@joeconway.com>; +Cc: pgsql-interfaces
And FWIW from my end, an array that cannot contain null values seriously
affects the ability to utilize this tool in an application with any degree
of sophistication. As it stands now, if I have a bad value, I must
substitute a dummy value :( or null out the whole array and lose a lot of
info :(( One of the reasons we are testing the limits of postgreSQL is
because these features separate it from some of the other options. Hope to
see this fixed! Thanks for the feedback and for listening to me vent.
Kathy
At 05:58 PM 9/10/2004, Bruce Momjian wrote:
>Joe Conway wrote:
> > Bruce Momjian wrote:
> > > Kathy Smith wrote:
> > >>I understand from searching around that it is on the "To Do" list to
> allow
> > >>null values in arrays. Can anyone tell me where this is in the
> > >>implementation process and/or if there is a work around?
> > >
> > > Uh, no one is implementing it and there is no workaround. :-)
> > >
> > > If you are considering coding it, read the developers FAQ>
> > >
> >
> > FWIW, in the past I've "made noises" about implementing support for NULL
> > array elements. I couldn't find the time to do it for 8.0, but I'm
> > hopeful that I will be able to find the time to do it for 8.1. However
> > if someone else wants to have at it, don't let me get in the way ;-)
>
>OK, great.
>
>--
> Bruce Momjian | http://candle.pha.pa.us
> pgman@candle.pha.pa.us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania 19073
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2004-09-21 15:32 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-07 22:20 Adding null values to arrays Kathy Smith <ksmith@lanl.gov>
2004-09-10 21:26 ` Bruce Momjian <pgman@candle.pha.pa.us>
2004-09-10 22:32 ` Joe Conway <mail@joeconway.com>
2004-09-10 23:58 ` Bruce Momjian <pgman@candle.pha.pa.us>
2004-09-21 15:32 ` Kathy Smith <ksmith@lanl.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox