pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Papp, Gyozo <pgerzson@freestart.hu>
To: Ruben Vivas <ruben.vivas@explorersystem.com>
To: pgsql-php@postgresql.org
Subject: Re: RV: calling a pl/pgsql function with array in argument
Date: Tue, 23 Apr 2002 00:53:20 +0200
Message-ID: <002d01c1ea50$805c4b20$01fdfea9@jaguar> (raw)
References: <NGBBLEDNCLEHAAFIPFNNEEAOCAAA.ruben.vivas@explorersystem.com>

this is a little bit hidden information somewhere in the manual.
Array types is the same the corresponding data type but 
prepended with an underscore '_', e.g:

_int4
_date
_smallint

btw, you cannot pass PHP array to plpgsql function. You need to 
convert it to string like:

 {1,2,23,45}

{   -- start array 
,,  -- comma separated values 
}   -- closing tag

here is my quote function to PG:

function quote($var, $type, $empty_null = TRUE)
{
 if ( empty($var) && $empty_null ){
  return 'NULL';
 }
 if ( $type{0} == '_' ){
  $type = substr($type, 1);
  $temp = "'{";
  foreach ( $var as $item ){
   $temp .= quote($item, $type).',';
  }
  $temp = substr($temp, 0, -1);
  return $temp ."}'";
 }
 switch ( $type ){
 case 'int':
  return intval($var);
 case 'bool':
  return ($var ? "'t'::bool": "'f'::bool"); 
 case 'date':
  if ( is_numeric($var) ) { // echo timestamp-kent kezeli
   return date("'Y-m-d'", $var);
  }
  // ha ez sem, akkor sima szovegkent tovabbadja
 case 'text':
  if (!get_magic_quotes_gpc()) {
    $var = addslashes($var);
  }
  return '\''.$var.'\'';
 default: trigger_error("unknown type : $type ($value)", E_USER_ERROR);
 }
} 
----- Original Message ----- 
From: "Ruben Vivas" <ruben.vivas@explorersystem.com>
To: <pgsql-php@postgresql.org>
Sent: Monday, April 22, 2002 10:18 PM
Subject: [PHP] RV: calling a pl/pgsql function with array in argument


| Hello, i am tryin to pass an array like argument to a pl/pgsql function but
| i can not find the correct data type in te function.
| 
| i am using php.
| 
| ex: $dato[][] is the array using php, and i need call:
| 
| 1. $res = fn_vea ($dato);   ?????
| 
| 2. in pl/pgsql CREATE FUNCTION fn_vea (integer [][]) RETURNS varchar (25) AS
| .........
| 
| 
| does it work??
| thank you
| 
| 
| ---------------------------(end of broadcast)---------------------------
| TIP 6: Have you searched our list archives?
| 
| http://archives.postgresql.org




view thread (2+ messages)

Message-ID: <002d01c1ea50$805c4b20$01fdfea9@jaguar>
Permalink:  ../002d01c1ea50$805c4b20$01fdfea9@jaguar/
Also on:    postgresql.org/message-id/002d01c1ea50$805c4b20$01fdfea9@jaguar

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: pgerzson@freestart.hu, ruben.vivas@explorersystem.com
  Subject: Re: RV: calling a pl/pgsql function with array in argument
  In-Reply-To: <002d01c1ea50$805c4b20$01fdfea9@jaguar>
  References: <NGBBLEDNCLEHAAFIPFNNEEAOCAAA.ruben.vivas@explorersystem.com> <002d01c1ea50$805c4b20$01fdfea9@jaguar>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox