Skip site navigation (1) Skip section navigation (2)

Re: arrays as input parameter for c functions

From: Joe Conway <mail(at)joeconway(dot)com>
To: Alexaki Sofia <alexaki(at)ics(dot)forth(dot)gr>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: arrays as input parameter for c functions
Date: 2002-07-12 15:57:31
Message-ID: 3D2EFC6B.1060900@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
Alexaki Sofia wrote:
> thank you for your answer.
> 
> Could you tell me how such a function is it called?
> 
> Let's say that the function is test(text[])
> how can I call this function from a sql command, i.e., what
> will be teh value of the input parameters?
> 
> select test(?????????)
> 

See contrib/dblink in CVS HEAD, specifically dblink_build_sql_insert(), 
dblink_build_sql_delete(), or dblink_build_sql_update(). These functions 
accept text arrays (and int2vector) as input. In the README there are 
usage examples.

HTH,

Joe




In response to

pgsql-interfaces by date

Next:From: Darko PrenosilDate: 2002-07-12 18:14:32
Subject: Re: dbf2pg, visual foxpro and other nonsense
Previous:From: Tom LaneDate: 2002-07-12 15:26:48
Subject: Re: Wish List: Client access to NUMERIC/DECIMAL type functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group