Re: Perl DBI and placeheld values - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Perl DBI and placeheld values
Date
Msg-id 20030130144102.GB32517@wolff.to
Whole thread Raw
In response to Perl DBI and placeheld values  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-general
On Wed, Jan 29, 2003 at 22:30:49 +0000,
  "Nigel J. Andrews" <nandrews@investsystems.co.uk> wrote:
>
> So just how do others manage this situation without resorting to special casing
> everything?

In this particular case you could use 'now' instead of current_timestamp.
In some other cases you might be able to use default to use the default
value.
In general you probably want two different sql statements and not try
to mix constant data and function calls in the same prepared statement.

pgsql-general by date:

Previous
From: Renê Salomão
Date:
Subject: Weird Behavior!!!
Next
From: "Patrick Bye (WFF)"
Date:
Subject: Re: Problem starting postmaster at startup