Thread: DBD::PG - any works to be compatile with 7.3 ?

DBD::PG - any works to be compatile with 7.3 ?

From
Oleg Bartunov
Date:
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



Re: DBD::PG - any works to be compatile with 7.3 ?

From
Bruce Momjian
Date:
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,
Pennsylvania19073
 


Re: DBD::PG - any works to be compatile with 7.3 ?

From
Oleg Bartunov
Date:
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



Re: DBD::PG - any works to be compatile with 7.3 ?

From
Bruce Momjian
Date:
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,
Pennsylvania19073
 


Re: DBD::PG - any works to be compatile with 7.3 ?

From
Oleg Bartunov
Date:
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



integer array, push and pop

From
"Ryan Mahoney"
Date:
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





Re: integer array, push and pop

From
Teodor Sigaev
Date:
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




Re: integer array, push and pop

From
Ryan Mahoney
Date:
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
> 
> 
> 



Re: integer array, push and pop

From
Ryan Mahoney
Date:
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