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
.



Relevant Pages

  • Re: Need your help [arguments for open source databases]
    ... >> I would like to have your opinions about open source databases versus ... >> in the universe of relational databases. ... The main difference between PostgreSQL and Oracle is manageability. ...
    (RedHat)
  • Re: postgres to mysql
    ... Ich meine, Du willst auf ein System replizieren, ... Dort gibt es ein Kapitel "Converting from other Databases to PostgreSQL" ...
    (de.comp.datenbanken.mysql)
  • Re: Database similar to MS Access for LInux?
    ... >> the application and they are run sequentially and the total time taken ... > Look at mySql and postgresql. ... > databases can be accessed from almost all programming languages, ... Besides VBA, I use ...
    (alt.os.linux)
  • Re: [PHP] Re: Getting last record ID created from DB
    ... There in lies the biggest problem with LAMP, and that's MySQL. ... They use PostgreSQL and we do have a auto incremented unique id ... but rather a sequence value. ... I guess maybe most databases support the notion of "auto number" in some ...
    (php.general)
  • Re: Free alternatives to SQL Server
    ... > PostgreSQL and Firebird. ... PS: don't even think of MySQL:) ... > data providers for these databases. ...
    (microsoft.public.dotnet.general)