Thread: Re: [SQL] PL/Perl?

I'm currently using DBI/DBD with perl_mod/embperl/Apache.
I try to find a way to generalize the aggregate functions that Pg lack
intead of fetch data and perform the fucntions in Perl-subs.

Thanks.

>Date: Thu, 25 Feb 1999 08:25:04 +0000 (   )
>From: "Victor M. Mondragon A." <mdragon@vera.net>
>To: "Dr. Nisai Wanakule" <nisai@m1p17-235.waterauthority.state.fl.us>
>cc: pgsql-sql@postgreSQL.org
>Subject: Re: [SQL] PL/Perl?
>MIME-Version: 1.0
>
>
>Try DBI and DBD you can fetch them from the CPAN.
>
># perl -MCPAN -e 'install DBI'
># perl -MCPAN -e 'install DBD::Pg'
>
>
>---------------------------------------------------------------------------
>Victor Manuel Mondragon                                    mdragon@vera.net
>---------------------------------------------------------------------------
>
>On Wed, 24 Feb 1999, Dr. Nisai Wanakule wrote:
>
>> Is there such thing as PL for Perl?
>> If there is, please direct me to the pertinent document.
>> If not, is there a plan in working?
>>
>> Thanks.
>>
>> --
>> Nisai Wanakule, PH.D., P.E.
>> Tampa Bay Water
>> 2535 Landmark Dr., Suite 211
>> Clearwater, FL 33761
>> Tel 727/791-2373
>> Fax 727/791-2388
>> SunCom: 513-7010
>>
>>
>>
>


--
Nisai Wanakule, PH.D., P.E.
Tampa Bay Water
2535 Landmark Dr., Suite 211
Clearwater, FL 33761
Tel 727/791-2373
Fax 727/791-2388
SunCom: 513-7010

Is there a summary anywhere describing
OID behavior?  Specificially, what you
can do with the system generated column
and what you cannot do?

For instance,

a) You cannot update it.
b) You can index it.

From what I remember, someone said that
you could export data with OID and
then import it.

When is the above true?  When the import
and export are performed on the same
database?  If you change databases, etc?

In particular, knowing how it is used
internally would help a great deal.

Thank you!

Clark Evans

I tried:

SELECT * FROM DB_A.MY_TABLE;

from DB_B and it did not like the
syntax.  I assume that you cannot
select across database/schemas.

Is this correct?

:) Clark Evans