Search Postgresql Archives

Re: plpython function with dictionary as function argument?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



gherzig@xxxxxxxxxxx wrote:
> Hi all. I need to know if it is possible to call a plpython stored funcion
> with an dictionary as single argument:
> 
> Suppose this python structure:
> 
> someDict = {
>             'field1': 'Foo',
>             'creepyfield': 'Bar'
>             }
> 
> The data base connection
> CONN = pg.connect()....
> 
> I want some pypgslq function
> 
> CREATE myfunction ( __dictionary__) returns void
> AS
> .... (process)
> LANGUAGE pythonu
> 
> and (the desired goal) be able to execute
> CONN.execute("select * from myfunction (someDict)")

Marshal someDict and unmarshal it in your function.  Marshal is *very* fast.

-- 
Peter Fein                 pfein@xxxxxxxxx                 773-575-0694

Basically, if you're not a utopianist, you're a schmuck. -J. Feldman

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux