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

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


That the way:
$arg1 = $cookieValue;
$arg2 = $dbh->quote ( $ueberschrift );
$arg3 = $dbh->quote ( $beschreibung );
$arg4 = $system_zeit;
$arg5 = "2001-11-11 11:11:11";
$arg6 = $startpreis;
$arg7 = $startpreis;
$arg8 = $kategorie_nummer;

$result = $dbh->prepare ( "SELECT neue_auktion ( ?, ?::text, ?::text,
?::timestamp, ?::timestamp, ?::numeric, ?::numeric, ?::numeric ) " ) or die
"Vorbereitung nicht durchfuehrbar!\n";
$result->bind_param ( 1, $arg1 );
$result->bind_param ( 2, $arg2 );
$result->bind_param ( 3, $arg3 );
$result->bind_param ( 4, $arg4 );
$result->bind_param ( 5, $arg5 );
$result->bind_param ( 6, $arg6 );
$result->bind_param ( 7, $arg7 );
$result->bind_param ( 8, $arg8 );
$result->execute() or die "Abfrage nicht ausfuehrbar -suchprofil!
$DBI::errstr\n";
$result->finish();

This works, it writes into the database. Hurra, yea :-)))))

Gruss Christian

--
DSL-Aktion wegen großer Nachfrage bis 28.2.2006 verlängert:
GMX DSL-Flatrate 1 Jahr kostenlos* http://www.gmx.net/de/go/dsl


- - - - - - - 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
    ... Calling a PostgreSQL function via DBI ... However I'm still concerned with why you need the nonportable form of ... So it doesn't has to be portable for other databases. ...
    (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)