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! */