RE: Calling a PostgreSQL function via DBI

Vielen Glueck mit ihren Aufgabe an der Uni.

-Will

-----Original Message-----
From: Christian Stalp [mailto:christian.stalp@xxxxxx]
Sent: Thursday 23 February 2006 18:24
To: Rutherdale, Will
Cc: dbi-users@xxxxxxxx
Subject: RE: Calling a PostgreSQL function via DBI



I'm glad it worked.

However I'm still concerned with why you need the nonportable form of
??::text etc.

Is this because you are running a user defined function which has no
schema associated with it the way a regular table or view would?

Is there some way to make it more portable, i.e. not needing to specify
explicit types for columns?

-Will


Yes this is true. Its a PLpgsql-function. This runs only on PostgreSQL and I
think this "::type"-form is also only usable under postgreSQL?!? But I have
to do it this way. Its a project for the university, and its focus on
databases. So it doesn't has to be portable for other databases. It is
important that we become familiar with database-procedures.

Gruss Christian

--
Lust, ein paar Euro nebenbei zu verdienen? Ohne Kosten, ohne Risiko!
Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner


- - - - - - - Appended by Scientific-Atlanta, Inc. - - - - - - -
This e-mail and any attachments may contain information which is confidential, proprietary, privileged or otherwise protected by law. The information is solely intended for the named addressee (or a person responsible for delivering it to the addressee). If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete it from your computer.

.

Relevant Pages

  • RE: Calling a PostgreSQL function via DBI
    ... However I'm still concerned with why you need the nonportable form of ??::text etc. ... Calling a PostgreSQL function via DBI ... "Vorbereitung nicht durchfuehrbar!\n"; ...
    (perl.dbi.users)
  • RE: Calling a PostgreSQL function via DBI
    ... If you try 'man DBI' or read one of the other available references, it will make this point clear. ... However, using prepareand bind_paramis even more portable, if you can get it to work for calling predefined functions. ... Calling a PostgreSQL function via DBI ...
    (perl.dbi.users)