From hareldvd@gmail.com Wed May  19 14:57:05 2010
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id B31C065B3C5
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 19 May 2010 11:57:05 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 45037-09 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 19 May 2010 14:56:56 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-fx0-f46.google.com (mail-fx0-f46.google.com
	[209.85.161.46])
	by mail.postgresql.org (Postfix) with ESMTP id E626565B3C2
	for <pgsql-sql@postgresql.org>; Wed, 19 May 2010 11:56:57 -0300 (ADT)
Received: by fxm10 with SMTP id 10so2439102fxm.19
	for <pgsql-sql@postgresql.org>; Wed, 19 May 2010 07:56:55 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from
	:user-agent:mime-version:to:subject:content-type;
	bh=cenJFuRzS9lhYV1H6BwpbYdhlcZAqj/N/QXuWO5upnM=;
	b=WP4X6o3e0tMGERGXbI5d70wMLhzqLdn33BqkbbYVGRxEMAHchnUKxZxgSWk0OpSvxh
	ltLU7vs+dybjIq6AwYGEIiMjjwiLEhJ5oY2kilfjOvmvnd1PFdnzLao/TipuS3pRC67Y
	TsddJ/txgEs43BtKiOtS3+/u6iN05pmc0fPY8=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:subject
	:content-type;
	b=usI4XQ8wX9vtKVtHGyWTaaVw/3w76mTRT/2jZxSXq59OUBTht401/sz62liZb22lw9
	5lVcr9B+muhRis2H2p4HCEnQzOKDtKVsj4JcUY4XQJ6/ix2VlwjXN0sJieBsTxmelnvU
	LUoE6lVtHwKe8DBUb5N0kO1RUFJDYUmbL3tww=
Received: by 10.102.132.6 with SMTP id f6mr6712118mud.108.1274281015620;
	Wed, 19 May 2010 07:56:55 -0700 (PDT)
Received: from [192.168.1.4] (bzq-84-109-195-101.red.bezeqint.net
	[84.109.195.101])
	by mx.google.com with ESMTPS id s17sm24342355bkd.16.2010.05.19.07.56.54
	(version=SSLv3 cipher=RC4-MD5); Wed, 19 May 2010 07:56:55 -0700 (PDT)
Message-ID: <4BF3FC34.3050006@gmail.com>
Date: Wed, 19 May 2010 17:56:52 +0300
From: David Harel <hareldvd@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.1.9) Gecko/20100423 Thunderbird/3.0.4
MIME-Version: 1.0
To: postgres sql <pgsql-sql@postgresql.org>
Subject: user function and bind
Content-Type: multipart/alternative;
	boundary="------------040805060509030603070701"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.811 tagged_above=-5 required=5 tests=BAYES_50=0.8,
	HTML_MESSAGE=0.001, T_FILL_THIS_FORM_SHORT=0.01
X-Spam-Level: 
X-Archive-Number: 201005/90
X-Sequence-Number: 34138

This is a multi-part message in MIME format.
--------------040805060509030603070701
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,
I need an example how to write user function with columns binding and 
how to use it on PHP

-- 
Thanks.

David Harel,

==================================

Home office +972 77 7657645
Cellular:   +972 54 4534502
Snail Mail: Amuka
             D.N Merom Hagalil
             13802
             Israel
Email:      hareldvd@ergolight-sw.com



--------------040805060509030603070701
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html style="direction: ltr;">
<head>

<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body style="direction: ltr;" text="#000000" bgcolor="#ffffff">
<font size="+1"><font face="Arial">Hi, <br>
I need an example how to write user function with columns binding and
how to use it on PHP</font></font><br>
<pre class="moz-signature" cols="72">-- 
Thanks.

David Harel,

==================================

Home office +972 77 7657645
Cellular:   +972 54 4534502
Snail Mail: Amuka
            D.N Merom Hagalil
            13802
            Israel
Email:      <a class="moz-txt-link-abbreviated" href="mailto:hareldvd@ergolight-sw.com">hareldvd@ergolight-sw.com</a>

</pre>
</body>
</html>

--------------040805060509030603070701--



From justin@magwerks.com Wed May  19 15:12:41 2010
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id AF31665B0BE
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 19 May 2010 12:12:41 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 62319-02 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 19 May 2010 15:12:30 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.magwerks.com (mail.magwerks.com [209.248.233.131])
	by mail.postgresql.org (Postfix) with ESMTP id D96BB684810
	for <pgsql-sql@postgresql.org>; Wed, 19 May 2010 12:12:29 -0300 (ADT)
Received: from [192.168.1.35] by mail.magwerks.com (GMS
	15.01.3664/RS2750.00.1b502c7c) with ESMTP id cxzpeaaa for
	pgsql-sql@postgresql.org; Wed, 19 May 2010 11:12:29 -0400
Message-ID: <4BF40DA6.6080009@magwerks.com>
Date: Wed, 19 May 2010 11:11:18 -0500
From: Justin Graf <justin@magwerks.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US;
	rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
To: David Harel <hareldvd@gmail.com>
CC: postgres sql <pgsql-sql@postgresql.org>
Subject: Re: user function and bind
References: <4BF3FC34.3050006@gmail.com>
In-Reply-To: <4BF3FC34.3050006@gmail.com>
Content-Type: multipart/mixed; boundary="------------080107020208040307080201"
X-AntiSpam: Checked for restricted content by Gordano's AntiSpam Software
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.509 tagged_above=-5 required=5 tests=BAYES_05=-0.5,
	HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201005/91
X-Sequence-Number: 34139

This is a multi-part message in MIME format.
--------------080107020208040307080201
Content-Type: multipart/alternative;
	boundary="------------020603020708070301050508"


--------------020603020708070301050508
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

On 5/19/2010 9:56 AM, David Harel wrote:
> Hi,
> I need an example how to write user function with columns binding and 
> how to use it on PHP
> -- 
> Thanks.
>    


I'm not sure i understand your   question.  You want a function to 
return record type correct??








All legitimate Magwerks Corporation quotations are sent in a .PDF file attachment with a unique ID number generated by our proprietary quotation system. Quotations received via any other form of communication will not be honored.

CONFIDENTIALITY NOTICE: This e-mail, including attachments, may contain legally privileged, confidential or other information proprietary to Magwerks Corporation and is intended solely for the use of the individual to whom it addresses. If the reader of this e-mail is not the intended recipient or authorized agent, the reader is hereby notified that any unauthorized viewing, dissemination, distribution or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and destroy all occurrences of this e-mail immediately.
Thank you.

--------------020603020708070301050508
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html; charset=ISO-8859-1"
 http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
On 5/19/2010 9:56 AM, David Harel wrote:
<blockquote cite="mid:4BF3FC34.3050006@gmail.com" type="cite">
  <meta http-equiv="content-type"
 content="text/html; charset=ISO-8859-1">
  <font size="+1"><font face="Arial">Hi, <br>
I need an example how to write user function with columns binding and
how to use it on PHP</font></font><br>
  <pre class="moz-signature" cols="72">-- 
Thanks.
  </pre>
</blockquote>
<br>
<br>
I'm not sure i understand your &nbsp; question.&nbsp; You want a function to
return record type correct??<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
All legitimate Magwerks Corporation quotations are sent in a .PDF file attachment with a unique ID number generated by our proprietary quotation system. Quotations received via any other form of communication will not be honored.
<BR>

<BR>

CONFIDENTIALITY NOTICE: This e&#045;mail&#044; including attachments&#044; may contain legally privileged&#044; confidential or other information proprietary to Magwerks Corporation and is intended solely for the use of the individual to whom it addresses. If the reader of this e&#045;mail is not the intended recipient or authorized agent&#044; the reader is hereby notified that any unauthorized viewing&#044; dissemination&#044; distribution or copying of this e&#045;mail is strictly prohibited. If you have received this e&#045;mail in error&#044; please notify the sender by replying to this message and destroy all occurrences of this e&#045;mail immediately.
<BR>

Thank you.
<BR>

</body>
</html>


--------------020603020708070301050508--

--------------080107020208040307080201
Content-Type: text/x-vcard; charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="justin.vcf"

begin:vcard
fn:Justin Graf
n:Graf;Justin
org:Magwerks Corp
adr:;;501 Commerce Drive;Danville ;IN;46122;USA
email;internet:justin@magwerks.com
tel;work:317-241-8011 ext 703
tel;fax:317-241-8015
x-mozilla-html:FALSE
url:www.magwerks.com
version:2.1
end:vcard


--------------080107020208040307080201--



From gwchamb@gmail.com Wed May  19 17:16:18 2010
Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 63E68684A53
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 19 May 2010 14:16:18 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 27224-02 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 19 May 2010 17:16:11 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-qy0-f198.google.com (mail-qy0-f198.google.com
	[209.85.221.198])
	by mail.postgresql.org (Postfix) with ESMTP id D766A684A50
	for <pgsql-sql@postgresql.org>; Wed, 19 May 2010 14:16:10 -0300 (ADT)
Received: by qyk36 with SMTP id 36so5110686qyk.19
	for <pgsql-sql@postgresql.org>; Wed, 19 May 2010 10:16:10 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:cc:content-type;
	bh=kVo6m4H3ayW2iZ8nV3E4hp3hFOdQMwr/8TIbWn/cs1Q=;
	b=PnCg+M7yVSaKjIdva//R4P6S0EOB6yryPMaBOKCRVDkREb9B6MQLpEToFm4kd6fBxL
	mXVl4uzw8q4tCEqkeg0BawUW1tSbftnc0I089IsL3DDAP1ZfsLxBFIxKQgLGHByDYNtf
	Ag5O0Ltbd97qY618g5aOfUj+EPoYeHnr2UZp8=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=wJ+EpvXBlAM/GLqwEKDoYfhAHU46i+JyV0AmoDvFfjYnVgqOATnZ5qGxtg/kBHjGQK
	qRjXKf6q9NMh3rdY4Hse6anEpyQ1evhIXhKUaXi0uZEjcK3hpk+O0kbeum4+cjEaR77o
	cYFn/KUe/5dQH6N+xeAxVeSsmB9w0F38eG3nQ=
MIME-Version: 1.0
Received: by 10.229.221.203 with SMTP id id11mr1905312qcb.85.1274289369872;
	Wed, 19 May 2010 10:16:09 -0700 (PDT)
Received: by 10.229.223.149 with HTTP; Wed, 19 May 2010 10:16:09 -0700 (PDT)
In-Reply-To: <4BF3FC34.3050006@gmail.com>
References: <4BF3FC34.3050006@gmail.com>
Date: Wed, 19 May 2010 13:16:09 -0400
Message-ID: <AANLkTimRVMixtmFlY3vU0766Ep4_rvAoA_oJnQZGsUuR@mail.gmail.com>
Subject: Re: user function and bind
From: Gary Chambers <gwchamb@gmail.com>
To: David Harel <hareldvd@gmail.com>
Cc: postgres sql <pgsql-sql@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201005/92
X-Sequence-Number: 34140

David,

> I need an example how to write user function with columns binding and how to
> use it on PHP

If I'm understanding your request correctly:

$dbh = pgpconnect("dbname=db host=dbhost user=dbuser password=pw");
$query = 'SELECT * FROM table WHERE x=$1 AND y=$2 AND z=$3';
$stmt = pg_query_params($dbh, $query, array($x, $y, $z));

-- Gary Chambers

/* Nothing fancy and nothing Microsoft! */