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_par
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 Cor
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
Isra
On Wed, May 19, 2010 at 12:26:07PM +0400, silly sad wrote:
> On 05/18/10 23:27, Kenneth Marshall wrote:
>
>> It works using 'now' and I assume that since curtime is
>
> now() is NOT the CURRENT timestamp in fact,
> it is about the timestamp of the current transaction has been started.
>
> it is the
On 2010-05-18, Kenneth Marshall wrote:
> I am trying to write a function that updates the
> date column to the current date. According to:
>
> http://www.postgresql.org/docs/8.4/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT
>
> you can use CURRENT_DATE. When I try to use it in
> the fo
Brian Modra wrote:
>>> It works using 'now' and I assume that since curtime is
>>> of type DATE that the assignment casts the return automatically
>>> to type DATE. Thank you for the ideas.
>>> [...]
>> What's wrong with Pavel's correct and to-the-point answer?
> No need actually to cast... jus
On 05/18/10 23:27, Kenneth Marshall wrote:
It works using 'now' and I assume that since curtime is
now() is NOT the CURRENT timestamp in fact,
it is about the timestamp of the current transaction has been started.
it is the really USEFUL value, still u have to remember this meaning.
--
Sent
