Search Postgresql Archives

Re: Variables inside plpythonu

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

 



On Sat, 12 May 2012 07:11:08 -0700
Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote:

> Something like this?:
> 
> create or replace function date_test(some_date date) returns void as
> $Body$
> date_plan = plpy.prepare("select id_fld from date_test where date_fld
> = $1", ["date"]) date_rs = plpy.execute(date_plan,[some_date])
> plpy.notice(date_rs[0]["id_fld"])
> $Body$
> language plpythonu;

Yes. Gave me the missing piece. Thanks a lot!

Cheers, 
Frank
-- 
Frank Lanitz <frank@xxxxxxxxxxxxxx>

Attachment: pgpQWbUXkvglb.pgp
Description: PGP signature


[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