Any news about new DBD::Pg ?
It's a stopper for many projects based on perl interface
to use 7.3.

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Wed, 2 Oct 2002 21:17:21 +0400 (MSD)
Oleg Bartunov <oleg@sai.msu.su>
DBD::PG - any works to be compatile with 7.3 ?
Oleg Bartunov wrote:
> Any news about new DBD::Pg ?
> It's a stopper for many projects based on perl interface
> to use 7.3.

I have created a gborg project for DBD::Pg and four people have
subscribed.  I will work with them to improve the driver.

-- 
  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

Sat, 19 Oct 2002 22:42:07 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: DBD::PG - any works to be compatile with 7.3 ?
On Sat, 19 Oct 2002, Bruce Momjian wrote:

> Oleg Bartunov wrote:
> > Any news about new DBD::Pg ?
> > It's a stopper for many projects based on perl interface
> > to use 7.3.
>
> I have created a gborg project for DBD::Pg and four people have
> subscribed.  I will work with them to improve the driver.

Does this means you've taken a full responsibillity for DBD::Pg ?
What's about CPAN where people used to find DBD::Pg ?

>
>

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Sun, 20 Oct 2002 08:40:02 +0400 (MSD)
Oleg Bartunov <oleg@sai.msu.su>
Re: DBD::PG - any works to be compatile with 7.3 ?
Oleg Bartunov wrote:
> On Sat, 19 Oct 2002, Bruce Momjian wrote:
> 
> > Oleg Bartunov wrote:
> > > Any news about new DBD::Pg ?
> > > It's a stopper for many projects based on perl interface
> > > to use 7.3.
> >
> > I have created a gborg project for DBD::Pg and four people have
> > subscribed.  I will work with them to improve the driver.
> 
> Does this means you've taken a full responsibillity for DBD::Pg ?
> What's about CPAN where people used to find DBD::Pg ?

CPAN will be updated by David Wheeler, already a member of the gborg
DBD:pg group.  He has already been assigned CPAN ownership from the
previous maintainer.

-- 
  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

Sun, 20 Oct 2002 00:41:08 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: DBD::PG - any works to be compatile with 7.3 ?
On Sun, 20 Oct 2002, Bruce Momjian wrote:

> Oleg Bartunov wrote:
> > On Sat, 19 Oct 2002, Bruce Momjian wrote:
> >
> > > Oleg Bartunov wrote:
> > > > Any news about new DBD::Pg ?
> > > > It's a stopper for many projects based on perl interface
> > > > to use 7.3.
> > >
> > > I have created a gborg project for DBD::Pg and four people have
> > > subscribed.  I will work with them to improve the driver.
> >
> > Does this means you've taken a full responsibillity for DBD::Pg ?
> > What's about CPAN where people used to find DBD::Pg ?
>
> CPAN will be updated by David Wheeler, already a member of the gborg
> DBD:pg group.  He has already been assigned CPAN ownership from the
> previous maintainer.

Good. I was afraid about diverging of development. Now, I have an issue for
the driver - support of user defined types. We already have looked into sources
and think it's doable.

>
>

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Sun, 20 Oct 2002 15:39:24 +0400 (MSD)
Oleg Bartunov <oleg@sai.msu.su>
Re: DBD::PG - any works to be compatile with 7.3 ?
Hi Oleg (and pgsql hackers!),

Recently I encountered a problem attempting to use the integer array
function for pushing an integer onto an integer array field.

Can you write an example of a sql statement for pushing a single value onto
an integer array and for popping a specific value off of an integer array?
I see the function in the documentation, but the actual statement syntax to
use is not clear to me.

Thanks for any help you can provide!

Ryan Mahoney




Mon, 21 Oct 2002 16:19:32 -0400
"Ryan Mahoney" <ryan@paymentalliance.net>
integer array, push and pop
regression=# select '{124,567,66}'::int[] + 345;
      ?column?
------------------
  {124,567,66,345}
(1 row)
regression=# select '{124,567,66}'::int[] + '{345,1}'::int[];
       ?column?
--------------------
  {124,567,66,345,1}
(1 row)
select '{124,567,66}'::int[] - 567;
  ?column?
----------
  {124,66}
(1 row)
regression=# select '{124,567,66}'::int[] - '{567,66}';
  ?column?
----------
  {124}
(1 row)


Ryan Mahoney wrote:
> Hi Oleg (and pgsql hackers!),
> 
> Recently I encountered a problem attempting to use the integer array
> function for pushing an integer onto an integer array field.
> 
> Can you write an example of a sql statement for pushing a single value onto
> an integer array and for popping a specific value off of an integer array?
> I see the function in the documentation, but the actual statement syntax to
> use is not clear to me.
> 
> Thanks for any help you can provide!
> 
> Ryan Mahoney
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
> 

-- 
Teodor Sigaev
teodor@stack.net



Tue, 22 Oct 2002 12:07:23 +0400
Teodor Sigaev <teodor@stack.net>
Re: integer array, push and pop
This is excellent!  Thanks so much!

-r

On Tue, 2002-10-22 at 04:07, Teodor Sigaev wrote:
> regression=# select '{124,567,66}'::int[] + 345;
>       ?column?
> ------------------
>   {124,567,66,345}
> (1 row)
> regression=# select '{124,567,66}'::int[] + '{345,1}'::int[];
>        ?column?
> --------------------
>   {124,567,66,345,1}
> (1 row)
> select '{124,567,66}'::int[] - 567;
>   ?column?
> ----------
>   {124,66}
> (1 row)
> regression=# select '{124,567,66}'::int[] - '{567,66}';
>   ?column?
> ----------
>   {124}
> (1 row)
> 
> 
> Ryan Mahoney wrote:
> > Hi Oleg (and pgsql hackers!),
> > 
> > Recently I encountered a problem attempting to use the integer array
> > function for pushing an integer onto an integer array field.
> > 
> > Can you write an example of a sql statement for pushing a single value onto
> > an integer array and for popping a specific value off of an integer array?
> > I see the function in the documentation, but the actual statement syntax to
> > use is not clear to me.
> > 
> > Thanks for any help you can provide!
> > 
> > Ryan Mahoney
> > 
> > 
> > 
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
> > 
> 
> -- 
> Teodor Sigaev
> teodor@stack.net
> 
> 
> 


22 Oct 2002 10:41:06 -0400
Ryan Mahoney <ryan@paymentalliance.net>
Re: integer array, push and pop
What version of postgres are you using?  I am using PostgreSQL 7.3b1 on
i686-pc-linux-gnu, compiled by GCC 2.96 and when I execute the following
statement:

select '{124,567,66}'::int[] + 345;

I get the error:

ERROR:  cache lookup failed for type 0

Any ideas?

Thanks for your help!

-r


31 Oct 2002 14:07:50 -0500
Ryan Mahoney <ryan@paymentalliance.net>
Re: integer array, push and pop